Re: [BUGS] inserting binary in a bytea field

2000-12-01 Thread Tom Lane
Olivier Jeannet <[EMAIL PROTECTED]> writes: > Is this normal ? > Am I supposed to get binary values as escaped ASCII, Yes. Otherwise you'd have big trouble with, for example, \000. You can use a binary cursor to read out unconverted data, but that might be more trouble than it's worth. There h

[BUGS] inserting binary in a bytea field

2000-12-01 Thread Olivier Jeannet
POSTGRESQL BUG REPORT TEMPLATE Your name : Olivier Jeannet Your email address : [EMAIL

Re: [BUGS] Re: [NOVICE] RE: iofflush psql 7.0.3 coredump on RH 6.1

2000-12-01 Thread Thomas Lockhart
> Odd. I'm using 4.0 here without any difficulty, and I don't recall > anyone reporting similar problems with recent readlines (I was afraid > you had a 2.something version...). Has anyone else seen a problem with > 4.0.1? We just ran across a problem with 3.x vs 4.x libraries when installing a

[BUGS] Re: [NOVICE] RE: iofflush psql 7.0.3 coredump on RH 6.1

2000-12-01 Thread Tom Lane
Rasputin <[EMAIL PROTECTED]> writes: >> If you find that a newer libreadline fixes it, we'd like to know what >> the old and new libreadline versions are ... > It did. > The offender was readline-4.0.1 > (to be fair I don't think it's the default on 6.1 - STR upgrading it to > fix *another* bug

[BUGS] dump of functions does not handle backslashes correctly

2000-12-01 Thread Robert B. Easter
If you create a function from psql like: CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; CREATE FUNCTION "atestfun" ( ) RETURNS text

[BUGS] Re: [NOVICE] RE: iofflush psql 7.0.3 coredump on RH 6.1

2000-12-01 Thread Tom Lane
Rasputin <[EMAIL PROTECTED]> writes: > In this case, disabling readline starts up the client OK. > I'll try upgrading readline on this system ,and see what happens. I was just going to suggest that. Did you compile Postgres from source, or is this an assemblage of RPMs? There have been enough