Re: oidin error when parsing XML documents

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Simon Kelly" <kelly(at)ipe(dot)fzk(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: oidin error when parsing XML documents
Date: 2002-11-12 13:26:47
Message-ID: 23375.1037107607@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Simon Kelly" <kelly(at)ipe(dot)fzk(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-11-12 14:27:08 Re: return column id from insert
Previous Message Simon Kelly 2002-11-12 12:02:36 oidin error when parsing XML documents