[jira] Commented: (DDLUTILS-161) PostgreSQL Blob type mapping should be OID in v8

["Thomas Dudziak (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DDLUTILS-161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12478693 ] 

Thomas Dudziak commented on DDLUTILS-161:
-----------------------------------------

Mhmm, AFAICT bytea is the correct type (see e.g. http://www.postgresql.org/docs/8.1/static/datatype-binary.html vs. http://www.postgresql.org/docs/8.1/static/datatype-oid.html). Also, blobs work fine (there are unit tests for that and they pass in PostgreSql 8.1 using the 8.1 driver).
Could you give more info as to what you did to produce this error ? E.g. the model XML, the connection info, Ant/code snippet etc.

> 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.