It seems like the JDBC BLOB type which creates a BLOB column on Oracle should create an OID column in PostgreSQL. Even though the Postgres JDBC driver's handling of OID columns is somewhat broken (ResultSet.getBlob() returns a java.sql.Blob OK, but getObject() returns a java.lang.Integer!) we can at least generate SQL that creates the table without a parse error:
-- Bill ================== tear here --- src/templates/sql/base/postgresql/db.props 16 Feb 2002 18:25:01 -0000 1.3 +++ src/templates/sql/base/postgresql/db.props 18 Feb 2002 17:56:00 -0000 @@ -28,7 +28,7 @@ DISTINCT = STRUCT = ARRAY = -BLOB = +BLOB = oid CLOB = text REF = -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
