Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group