DdlUtils
  1. DdlUtils
  2. DDLUTILS-161

PostgreSQL Blob type mapping should be OID in v8

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major 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

        Activity

        Richard Bounds created issue -
        Richard Bounds made changes -
        Field Original Value New Value
        Attachment TestPostgresBlob.java [ 12352920 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.2 [ 12312767 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.2 [ 12312767 ]
        Fix Version/s 1.3 [ 12313497 ]

          People

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

            Dates

            • Created:
              Updated:

              Development