Uploaded image for project: 'DdlUtils'
  1. DdlUtils
  2. DDLUTILS-161

PostgreSQL Blob type mapping should be OID in v8

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 1.3
    • Component/s: Core - PostgreSql
    • Labels:
      None
    • Environment:
      PostgreSQL 8.1.8 on Fedora core 6 (i386).

      Description

      For PostgreSQL v8 JDBC drivers the blob type maps to OID, not BYTEA:
      from here: http://doc.postgresintl.com/jdbc/ch08.html
      "....To use the Large Object functionality you can use either the LargeObject class provided by the PostgreSQLâ„¢ JDBC driver, or by using the getBLOB() and setBLOB() methods...."

      When using PostgreSQL (v7 or v8) with the v7 JDBC drivers BYTEA works fine, but with the v8 drivers you get an error message:
      ERROR: column "binvalue" is of type bytea but expression is of type oid

        Attachments

          Activity

            People

            • Assignee:
              tomdz Thomas Dudziak
              Reporter:
              richardbounds Richard Bounds
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: