I have added a description to the CVS and it will appear in 7.2. It is
in the development docs now.
Hi Barry,
I looked in the postgresql documentation and couldn't find any mention
of a bytea type. Well actually, I found ..
$ grep -i bytea *
bki-commands.html:bytea/TT
I heard it was fixed too but looking around, I found nothing. I added
it tonight to the types section.
Thomas,
You are correct about the poor documentation for bytea. I hear this is
fixed in 7.2 docs, but haven't verified. I learned about it myself by
looking at the internal pg_*
Hi Barry,
I looked in the postgresql documentation and couldn't find any mention
of a bytea type. Well actually, I found ..
$ grep -i bytea *
bki-commands.html:bytea/TT
catalog-pg-proc.html:bytea/TT
xfunc-c.html:bytea/TD
xfunc-c.html:(bytea *)/TD
but no real info on what it is, or no mention
Thomas,
You are correct about the poor documentation for bytea. I hear this is
fixed in 7.2 docs, but haven't verified. I learned about it myself by
looking at the internal pg_* tables and seeing how they used it.
I'm glad to hear that you have a workaround for your original issue.
thanks,
Thanks Barry,
I turned on debugging in postgresql. I found that the query is being truncated
and is not fully making it to the backend, therefore I'm getting the
Unterminated string error. I'll have a look into why and report back if
I find anything.
Cheers,
Tom.
On Tue, Aug 28, 2001 at
I found problem. My string has a null character in the middle of it. I
noticed from the Connection.java code that the null character idicates
end of query so I guess that is what is happening. I'll strip out my
null strings in the mean time as they are not needed before sending them
to the driver
Thomas,
The text datatypes in postgres (i.e. char, varchar, text) do not support
storing null characters. If your data contains nulls then you need to
use the binary datatype bytea. Unfortunately the JDBC drivers do not
currently support the bytea datatype.
thanks,
--Barry
Thomas O'Dowd