View Issue Details

IDProjectCategoryView StatusLast Update
0001652SymmetricDSImprovementpublic2014-06-16 20:27
ReporterelongAssigned Toelong 
PrioritynormalSeverityminorReproducibilityN/A
Status closedResolutionfixed 
Product Version3.6.0 
Target Version3.6.0Fixed in Version3.6.0 
Summary0001652: Add BLOB support to PostgreSQL bulk loader
DescriptionThe bulk loader for PostgreSQL cannot handle binary (BLOB) fields currently. Add support for BLOBs. Be careful to follow the character encoding scheme of the file and use escaping of characters when needed, f.e. using \x00 notation for bytes. Use the PostgreSQL COPY TABLE TO output as an example.
TagsNo tags attached.

Activities

elong

2014-04-04 17:05

developer   ~0000507

Kept with the CSV format and used \000 escaping for octal bytes. (Had trouble switching to the text format that supported \x00.)

Related Changesets

SymmetricDS: master 29481693

2014-04-04 17:02:53

erilong

Details Diff
0001652: Add BLOB support to PostgreSQL bulk loader
0001652
add - symmetric-client/src/test/java/org/jumpmind/symmetric/io/data/writer/AbstractBulkDatabaseWriterTest.java Diff File
mod - symmetric-client/src/test/java/org/jumpmind/symmetric/io/data/writer/MySqlBulkDatabaseWriterTest.java Diff File
add - symmetric-client/src/test/java/org/jumpmind/symmetric/io/data/writer/PostgresBulkDatabaseWriterTest.java Diff File
mod - symmetric-postgres/src/main/java/org/jumpmind/symmetric/io/data/writer/PostgresBulkDatabaseWriter.java Diff File

Issue History

Date Modified Username Field Change
2014-03-25 10:14 elong New Issue
2014-03-25 10:14 elong Status new => assigned
2014-03-25 10:14 elong Assigned To => elong
2014-04-04 17:05 elong Note Added: 0000507
2014-04-04 17:06 elong Status assigned => resolved
2014-04-04 17:06 elong Fixed in Version => 3.6.0
2014-04-04 17:06 elong Resolution open => fixed
2014-04-04 18:00 Changeset attached => SymmetricDS trunk r8130
2014-06-16 20:27 chenson Status resolved => closed
2015-07-30 21:49 Changeset attached => SymmetricDS master 29481693