|
Database.HDBC.PostgreSQL | Portability | portable | Stability | provisional | Maintainer | John Goerzen <jgoerzen@complete.org> |
|
|
|
|
|
Description |
HDBC driver interface for PostgreSQL 8.x
Written by John Goerzen, jgoerzen@complete.org
NOTE ON DATES AND TIMES
The recommended correspondence between PostgreSQL date and time types and HDBC SqlValue
types is:
- SqlLocalDate: DATE
- SqlLocalTimeOfDay: TIME WITHOUT TIME ZONE
- SqlZonedLocalTimeOfDay: TIME WITH TIME ZONE
- SqlLocalTime: TIMESTAMP WITHOUT TIME ZONE
- SqlZonedTime: TIMESTAMP WITH TIME ZONE
- SqlUTCTime: TIMESTAMP WITH TIME ZONE
- SqlDiffTime: INTERVAL
- SqlPOSIXTime: NUMERIC
- SqlEpochTime: INTEGER
- SqlTimeDiff: INTERVAL
Other combinations are possible, and may even be converted automatically.
The above simply represents the types that seem the most logical correspondence,
and thus are tested by the HDBC-PostgreSQL test suite.
|
|
Synopsis |
|
|
|
|
Connecting to Databases
|
|
|
Connect to a PostgreSQL server.
See http://www.postgresql.org/docs/8.1/static/libpq.html#LIBPQ-CONNECT for the meaning
of the connection string.
|
|
|
|
PostgreSQL Error Codes
|
|
When an SqlError is thrown, the field seState is set to one of the following
error codes.
|
|
|
Is set to "00000".
|
|
|
Is set to "01000".
|
|
|
Is set to "0100C".
|
|
|
Is set to "01008".
|
|
|
Is set to "01003".
|
|
|
Is set to "01007".
|
|
|
Is set to "01006".
|
|
|
Is set to "01004".
|
|
|
Is set to "01P01".
|
|
|
Is set to "02000".
|
|
|
Is set to "02001".
|
|
|
Is set to "03000".
|
|
|
Is set to "08000".
|
|
|
Is set to "08003".
|
|
|
Is set to "08006".
|
|
|
Is set to "08001".
|
|
sqlserverRejectedEstablishmentOfSqlconnection :: String | Source |
|
Is set to "08004".
|
|
|
Is set to "08007".
|
|
|
Is set to "08P01".
|
|
|
Is set to "09000".
|
|
|
Is set to "0A000".
|
|
|
Is set to "0B000".
|
|
|
Is set to "0F000".
|
|
|
Is set to "0F001".
|
|
|
Is set to "0L000".
|
|
|
Is set to "0LP01".
|
|
|
Is set to "0P000".
|
|
|
Is set to "21000".
|
|
|
Is set to "22000".
|
|
|
Is set to "2202E".
|
|
|
Same as arrayElementError.
|
|
|
Is set to "22021".
|
|
|
Is set to "22008".
|
|
|
Same as datetimeFieldOverflow.
|
|
|
Is set to "22012".
|
|
|
Is set to "22005".
|
|
|
Is set to "2200B".
|
|
|
Is set to "22022".
|
|
|
Is set to "22015".
|
|
|
Is set to "2201E".
|
|
|
Is set to "2201F".
|
|
|
Is set to "2201G".
|
|
|
Is set to "22018".
|
|
|
Is set to "22007".
|
|
|
Is set to "22019".
|
|
|
Is set to "2200D".
|
|
|
Is set to "22025".
|
|
|
Is set to "22P06".
|
|
|
Is set to "22010".
|
|
|
Is set to "22020".
|
|
|
Is set to "22023".
|
|
|
Is set to "2201B".
|
|
|
Is set to "22009".
|
|
|
Is set to "2200C".
|
|
|
Is set to "2200G".
|
|
|
Is set to "22004".
|
|
|
Is set to "22002".
|
|
|
Is set to "22003".
|
|
|
Is set to "22026".
|
|
|
Is set to "22001".
|
|
|
Is set to "22011".
|
|
|
Is set to "22027".
|
|
|
Is set to "22024".
|
|
|
Is set to "2200F".
|
|
|
Is set to "22P01".
|
|
|
Is set to "22P02".
|
|
|
Is set to "22P03".
|
|
|
Is set to "22P04".
|
|
|
Is set to "22P05".
|
|
|
Is set to "2200L".
|
|
|
Is set to "2200M".
|
|
|
Is set to "2200N".
|
|
|
Is set to "2200S".
|
|
|
Is set to "2200T".
|
|
|
Is set to "23000".
|
|
|
Is set to "23001".
|
|
|
Is set to "23502".
|
|
|
Is set to "23503".
|
|
|
Is set to "23505".
|
|
|
Is set to "23514".
|
|
|
Is set to "24000".
|
|
|
Is set to "25000".
|
|
|
Is set to "25001".
|
|
|
Is set to "25002".
|
|
|
Is set to "25008".
|
|
|
Is set to "25003".
|
|
inappropriateIsolationLevelForBranchTransaction :: String | Source |
|
Is set to "25004".
|
|
|
Is set to "25005".
|
|
|
Is set to "25006".
|
|
|
Is set to "25007".
|
|
|
Is set to "25P01".
|
|
|
Is set to "25P02".
|
|
|
Is set to "26000".
|
|
|
Is set to "27000".
|
|
|
Is set to "28000".
|
|
|
Is set to "2B000".
|
|
|
Is set to "2BP01".
|
|
|
Is set to "2D000".
|
|
|
Is set to "2F000".
|
|
|
Is set to "2F005".
|
|
|
Is set to "2F002".
|
|
|
Is set to "2F003".
|
|
|
Is set to "2F004".
|
|
|
Is set to "34000".
|
|
|
Is set to "38000".
|
|
|
Is set to "38001".
|
|
|
Is set to "38002".
|
|
|
Is set to "38003".
|
|
|
Is set to "38004".
|
|
|
Is set to "39000".
|
|
|
Is set to "39001".
|
|
|
Is set to "39004".
|
|
|
Is set to "39P01".
|
|
|
Is set to "39P02".
|
|
|
Is set to "3B000".
|
|
|
Is set to "3B001".
|
|
|
Is set to "3D000".
|
|
|
Is set to "3F000".
|
|
|
Is set to "40000".
|
|
|
Is set to "40002".
|
|
|
Is set to "40001".
|
|
|
Is set to "40003".
|
|
|
Is set to "40P01".
|
|
|
Is set to "42000".
|
|
|
Is set to "42601".
|
|
|
Is set to "42501".
|
|
|
Is set to "42846".
|
|
|
Is set to "42803".
|
|
|
Is set to "42830".
|
|
|
Is set to "42602".
|
|
|
Is set to "42622".
|
|
|
Is set to "42939".
|
|
|
Is set to "42804".
|
|
|
Is set to "42P18".
|
|
|
Is set to "42809".
|
|
|
Is set to "42703".
|
|
|
Same as invalidCursorName.
|
|
|
Same as invalidCatalogName.
|
|
|
Is set to "42883".
|
|
|
Same as invalidSqlStatementName.
|
|
|
Same as invalidSchemaName.
|
|
|
Is set to "42P01".
|
|
|
Is set to "42P02".
|
|
|
Is set to "42704".
|
|
|
Is set to "42701".
|
|
|
Is set to "42P03".
|
|
|
Is set to "42P04".
|
|
|
Is set to "42723".
|
|
|
Is set to "42P05".
|
|
|
Is set to "42P06".
|
|
|
Is set to "42P07".
|
|
|
Is set to "42712".
|
|
|
Is set to "42710".
|
|
|
Is set to "42702".
|
|
|
Is set to "42725".
|
|
|
Is set to "42P08".
|
|
|
Is set to "42P09".
|
|
|
Is set to "42P10".
|
|
|
Is set to "42611".
|
|
|
Is set to "42P11".
|
|
|
Is set to "42P12".
|
|
|
Is set to "42P13".
|
|
|
Is set to "42P14".
|
|
|
Is set to "42P15".
|
|
|
Is set to "42P16".
|
|
|
Is set to "42P17".
|
|
|
Is set to "44000".
|
|
|
Is set to "53000".
|
|
|
Is set to "53100".
|
|
|
Is set to "53200".
|
|
|
Is set to "53300".
|
|
|
Is set to "54000".
|
|
|
Is set to "54001".
|
|
|
Is set to "54011".
|
|
|
Is set to "54023".
|
|
|
Is set to "55000".
|
|
|
Is set to "55006".
|
|
|
Is set to "55P02".
|
|
|
Is set to "55P03".
|
|
|
Is set to "57000".
|
|
|
Is set to "57014".
|
|
|
Is set to "57P01".
|
|
|
Is set to "57P02".
|
|
|
Is set to "57P03".
|
|
|
Is set to "58030".
|
|
|
Is set to "58P01".
|
|
|
Is set to "58P02".
|
|
|
Is set to "F0000".
|
|
|
Is set to "F0001".
|
|
|
Is set to "P0000".
|
|
|
Is set to "P0001".
|
|
|
Is set to "P0002".
|
|
|
Is set to "P0003".
|
|
|
Is set to "XX000".
|
|
|
Is set to "XX001".
|
|
|
Is set to "XX002".
|
|
Produced by Haddock version 2.6.1 |