db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Richard Bounds (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-161) PostgreSQL Blob type mapping should be OID in v8
Date Thu, 01 Mar 2007 12:09:50 GMT
PostgreSQL Blob type mapping should be OID in v8

                 Key: DDLUTILS-161
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-161
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - PostgreSql
         Environment: PostgreSQL 8.1.8 on Fedora core 6 (i386).
            Reporter: Richard Bounds
         Assigned To: Thomas Dudziak

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

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message