[
https://issues.apache.org/jira/browse/DDLUTILS-161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Bounds updated DDLUTILS-161:
------------------------------------
Attachment: TestPostgresBlob.java
Unit test to reproduce the problem.
> 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
> Attachments: TestPostgresBlob.java
>
>
> 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.
