View Revisions: Issue #793
Summary | 0000793: Columns of type OID and LO in Postgres do not work with sym_trigger.use_stream_lobs set to 1 | ||
---|---|---|---|
Revision | 2012-08-29 20:19 by chenson | ||
Description | Columns of type OID in Postgres do not work with sym_trigger.use_stream_lobs set to 1. ExtractDataReader.enhanceWithLobsFromSourceIfNeeded needs to wrap the oid column with sym_largeobject to pull the data that is referenced by the oid column. |
||
Revision | 2012-08-29 20:56 by chenson | ||
Description | Columns of type OID in Postgres do not work with sym_trigger.use_stream_lobs set to 1. ExtractDataReader.enhanceWithLobsFromSourceIfNeeded needs to wrap the oid column with sym_largeobject to pull the data that is referenced by the oid column. In order to fix this I would probably refactor enhanceWithLobsFromSourceIfNeeded to call a method on the DatabasePlatform to selectEncodedLobData(BinaryEncoding, Table, Column lobColumn, pkArgs) so the PostgreSqlDatabasePlatform can override the method and use postgres specific apis (http://jdbc.postgresql.org/documentation/83/binary-data.html#binary-data-example). You might have to look at the type name to decide use the super implementation for bytea. |
||
Revision | 2012-09-07 12:36 by |
||
Description | Columns of type OID and LO in Postgres do not work with sym_trigger.use_stream_lobs set to 1. ExtractDataReader.enhanceWithLobsFromSourceIfNeeded needs to wrap the oid column with sym_largeobject to pull the data that is referenced by the oid column. |