Re: [BUGS] BUG #1087: psql dumps core on CTRL+ALT+\

2004-02-27 Thread Peter Eisentraut
PostgreSQL Bugs List wrote: > Entering CTRL+ALT+\ (backslash) causes psql to dump core: That is the very purpose of that key combination. The shell sends a SIGQUIT signal to the program, causing it to quit and dump core. You may find that quite a lot of programs dump core that way. If you don

[BUGS] BUG #1087: psql dumps core on CTRL+ALT+\

2004-02-27 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1087 Logged by: Roderick van Domburg Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: FreeBSD/sparc64 5.2-CURRENT (2004-02-20) Description:psql dumps core on CTRL+ALT+\ Details:

Re: [BUGS] intermittent error: 'variable not found in subplan target list'

2004-02-27 Thread Tom Lane
Damon Hart <[EMAIL PROTECTED]> writes: > Thanks for your response, the full original post follows, including both > scripts. Found it. The patch for 7.4.* is attached. It will appear in 7.4.2. regards, tom lane Index: src/backend/optimizer/plan/initsplan.c =

Re: [BUGS] BUG #1086: lower and upper functions

2004-02-27 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > lower and uper functions don't proces polish leters ąółęźżść At the moment we only support those in single-byte encodings (ie, don't use Unicode as the database encoding). Also, check that you initdb'd with the correct locale setting.

Re: [BUGS] BUG #1083: Insert query reordering interacts badly with

2004-02-27 Thread Bruno Wolff III
I am going to try to move this over the sql list, since it doesn't belong on bugs. On Tue, Feb 24, 2004 at 23:47:48 +1300, Martin Langhoff <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > >How about > > > >SELECT nextval('seq'); -- ignore result > > > >INSERT INTO ... VALUES (currval('seq

Re: [BUGS] intermittent error: 'variable not found in subplan target

2004-02-27 Thread Damon Hart
Tom Lane wrote: Damon Hart <[EMAIL PROTECTED]> writes: I had to remove the attached schema.sql file as the list manager refused the complete submission for overall message size (112KB). I tried to reduce the size of the data, but ran into trouble reproducing the error. You can send me t

[BUGS] BUG #1086: lower and upper functions

2004-02-27 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1086 Logged by: polrus Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: cygwin on xp Description:lower and upper functions Details: lower and uper functions don't proces poli