• Topic
  • Discussion
    • UdaWikiWeb.ServerAgentAdminPostgreSQL(Last) -- Owiki? , 2016-08-19 15:00:56 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2016-08-19 15:00:56

    Server Agent Administration

    PostgresSQL

    Table: 1. Default Rule Book settings

    Rule Book Section & parameters Default Rule Book Settings Notes
    [Environment POSTGRES]
    ;ODBC_CATALOGS Y

    Uncomment after loading odbccat defs

    Agent Section

    OpSysLogin= Yes; Users are validated against the operating system.

    The following options can be used in the ConnectOptions field of the rule book (oplrqb.ini) to override client Options settings:

    • -H
      Connect to postmaster on . This defaults to localhost if unspecified
    • -P
      Contact postmaster on port , which defaults to PGPORT (5432) is unspecified.
    • -T
      Disable ODBC transaction management. All transactions will be automatically committed. This prevents palloc() failures with out-of-memory errors when doing really big transactions such as Exporting 10000 records from MS/Access.

    Database Agent default name: pgr7_mv (or pgr7_sv which is single threaded)

    This ODBC database agent has been built using PostgreSQL release 7.2. Using this agent with a previous version of Postgres will probably fail. If you experience any problems with older releases, please try against release 7.2 first before contacting OpenLink.

    Data type Mapping from ODBC Data types to Postgres Data types

    This information can be queried by the SQLTypeInfo catalog call.

    Table: 2. Default Rule Book settings

    SQL type Postgres type
    SQL_CHAR char
    SQL_VARCHAR varchar
    SQL_LONGVARCHAR text
    SQL_DECIMAL varchar
    SQL_NUMERIC varchar
    SQL_BIT bit
    SQL_TINYINT int2
    SQL_SMALLINT int2
    SQL_INTEGER int4
    SQL_BIGINT varchar
    SQL_REAL float4
    SQL_DOUBLE float8
    SQL_FLOAT float8
    SQL_BINARY not supported
    SQL_VARBINARY not supported
    SQL_LONGVARBINARY not supported
    SQL_DATE not supported
    SQL_TIME not supported
    SQL_TIMESTAMP not supported

    Data type Mapping from Postgres Data types to ODBC Data types

    This information can be queried by the SQLColumns catalog call.

    Table: 3. Default Rule Book settings

    Postgres type SQL type Precision
    bool SQL_CHAR 1
    char SQL_CHAR 1
    name SQL_VARCHAR 32
    char16 SQL_CHAR 16
    int2 SQL_SMALLINT
    int4 SQL_INTEGER
    regproc SQL_VARCHAR 16
    text SQL_LONGVARCHAR 8000
    oid SQL_INTEGER (*)
    tid SQL_VARCHAR 19
    xid SQL_VARCHAR 12
    cid SQL_VARCHAR 3
    oid8 SQL_VARCHAR 89
    smgr SQL_VARCHAR 12
    char2 SQL_VARCHAR 2
    char4 SQL_VARCHAR 4
    char8 SQL_VARCHAR 8
    filename SQL_VARCHAR 255
    float4 SQL_REAL
    float8 SQL_DOUBLE
    abstime SQL_VARCHAR 60
    reltime SQL_VARCHAR 60
    tinterval SQL_VARCHAR 60
    unknown SQL_VARCHAR 255
    bpchar SQL_CHAR 255
    varchar SQL_VARCHAR 255
    date SQL_CHAR 10
    time SQL_CHAR 16
    other type SQL_LONGVARCHAR 8000

    (*) Note: An oid is returned as a SQL_INTEGER, because otherwise it would not be useable for SQLSpecialColumns.

    Binary data / large objects are not supported in this release.

    Referenced by...