Thread: oidin error when parsing XML documents

oidin error when parsing XML documents

From
"Simon Kelly"
Date:
Hi,

I am currently trying to set up postgresql as a relational backend data
storage to the eXist-0.8.1 XML-DB.  I am getting an error after most of the
data has been written into the db and is as follows.

 java.sql.SQLException: ERROR:  oidin: error in
"\000\000\000\000\000\000\030\365": can't parse
"\000\000\000\000\000\000\030\365"

 Has anyone seen a similar error, and what could be causing it?

 Cheers

 Simon

 Institut fuer
Prozessdatenverarbeitung
und Elektronik,
Forschungszentrum Karlsruhe GmbH,
Postfach 3640,
D-76021 Karlsruhe,
Germany.

 Tel: (+49)/7247 82-4042
E-mail : kelly@ipe.fzk.de


Re: oidin error when parsing XML documents

From
Tom Lane
Date:
"Simon Kelly" <kelly@ipe.fzk.de> writes:
>  java.sql.SQLException: ERROR:  oidin: error in
> "\000\000\000\000\000\000\030\365": can't parse
> "\000\000\000\000\000\000\030\365"

This looks like data intended for a bytea column is being sent to an oid
column instead.  Maybe some confusion about what datatype to be used for
binary data?

You'd probably get more useful help on the pgsql-jdbc list.  There is
a relevant-looking thread at
http://fts.postgresql.org/db/mw/msg.html?mid=1079079

            regards, tom lane