[DDLUTILS-161] PostgreSQL Blob type mapping should be OID in v8

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.3
• Component/s: Core - PostgreSql
• Environment: PostgreSQL 8.1.8 on Fedora core 6 (i386).
• Assignee: Thomas Dudziak
• Reporter: Richard Bounds
• Created: 01/Mar/07 12:08
• Updated: 03/Nov/08 22:06

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