Re: [GENERAL] CREATE DATABASE question.

2006-07-26 Thread Eric Faulhaber
ATE TABLE tableTest(var varchar); This lets psql interpret your connect request as a psql command instead of as an SQL statement. Regards, Eric Faulhaber ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-20 Thread Eric Faulhaber
Martijn van Oosterhout wrote: > On Thu, Jul 20, 2006 at 12:07:54PM -0400, Eric Faulhaber wrote: >>> Well, there's a really nasty workaround: create a cast from bytea to >>> text which doesn't change the value. This will get your data into the >>> dat

Re: [GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-20 Thread Eric Faulhaber
Martijn van Oosterhout wrote: > On Wed, Jul 19, 2006 at 06:06:08PM -0400, Eric Faulhaber wrote: >> Martijn van Oosterhout wrote: >>> On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote: >>>> OK, but now that this "feature" has been removed i

Re: [GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-19 Thread Eric Faulhaber
Martijn van Oosterhout wrote: > On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote: >> OK, but now that this "feature" has been removed in 8.1.4, how is this >> supposed to be handled, given that we don't control what string data >> we're hande

Re: [GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-19 Thread Eric Faulhaber
Tom Lane wrote: > Martijn van Oosterhout writes: >> The fact is that if you're using binary format paramaters and output >> you can put embedded nulls into strings and get them back out. > > Not any more ;-) > OK, but now that this "feature" has been removed in 8.1.4, how is this supposed to be

Re: [GENERAL] what step need to configure postgres for java application

2006-07-19 Thread Eric Faulhaber
e provided separately. See: http://jdbc.postgresql.org/ Drivers and docs are available there, respectively at: http://jdbc.postgresql.org/download.html http://jdbc.postgresql.org/documentation/81/index.html Regards, Eric Faulhaber ---(end of broadcast)-

Re: [GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-18 Thread Eric Faulhaber
Tom Lane wrote: > Eric Faulhaber <[EMAIL PROTECTED]> writes: >> OK, but this particular issue is something quite new to the latest >> version. > > Again, PG has never stored such data correctly. > Perhaps not, but it silently tolerated such data until this rel

Re: [GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-18 Thread Eric Faulhaber
Tom Lane wrote: > Eric Faulhaber <[EMAIL PROTECTED]> writes: >> Can anyone help me understand why converting the NULL code point () >> from UTF8 to ISO8859_1 is no longer legal in v8.1.4? > > Embedded nulls in text strings have never behaved sanely in PG ... or &

[GENERAL] UTF8 conversion differences from v8.1.3 to v8.1.4

2006-07-17 Thread Eric Faulhaber
ver with a ERRCODE_CHARACTER_NOT_IN_REPERTOIRE error. Thanks in advance for any assistance. Regards, Eric Faulhaber ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL