Ben Caradoc-Davies created GEOT-4040:
----------------------------------------
Summary: Support PostgreSQL 9 hex bytea output format to avoid
massive data corruption
Key: GEOT-4040
URL: https://jira.codehaus.org/browse/GEOT-4040
Project: GeoTools
Issue Type: New Feature
Components: jdbc-postgis plugin
Reporter: Ben Caradoc-Davies
Assignee: Justin Deoliveira
PostgreSQL 9 introduces a new default "hex" output format for bytea. This
results in massive silent data corruption.
The workaround is:
alter database DATABASENAME set bytea_output = 'escape';
http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT
http://www.postgresql.org/docs/9.0/static/datatype-binary.html
http://unicolet.blogspot.com.au/2012/01/grails-blobs-and-postgres-byteaoutput.html
See GEOT-3905:
{noformat}
Failed tests:
testRead(org.geotools.data.postgis.ps.PostgisLobTest): null
testWrite(org.geotools.data.postgis.ps.PostgisLobTest): null
testRead(org.geotools.data.postgis.PostgisLobTest): null
testWrite(org.geotools.data.postgis.PostgisLobTest): null
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://jira.codehaus.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
