db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DDLUTILS-161) PostgreSQL Blob type mapping should be OID in v8
Date Mon, 17 Sep 2007 01:06:35 GMT

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

Thomas Dudziak updated DDLUTILS-161:

    Fix Version/s: 1.2

> 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
>            Assignee: Thomas Dudziak
>             Fix For: 1.2
>         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.

View raw message