Re: [BUGS] variable not found in subplan target list? + test case

2003-11-25 Thread Klint Gore
On Tue, 25 Nov 2003 19:02:54 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Klint Gore <[EMAIL PROTECTED]> writes: > >> Can you send a test case with table and view definitions, it's hard to > >> generate one from just the information above. > > > ok. the last select generates the error. > > Hoo,

Re: [BUGS] SELECT with MANY tables

2003-11-25 Thread Tom Lane
Javier Carlos <[EMAIL PROTECTED]> writes: >When I make a SELECT with many tables (more than 12), postgresql eats all my > %CPU and I've waited more than 1 hour and stays the same. The weird thing is > that with 10 tables the same select with the same joins only takes about 5 > seconds. First I

Re: [BUGS] variable not found in subplan target list? + test case

2003-11-25 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: >> Can you send a test case with table and view definitions, it's hard to >> generate one from just the information above. > ok. the last select generates the error. Hoo, that was a fun one. Here's the patch. regards, tom lane ***

Re: [BUGS] 7.4RC2 PANIC: insufficient room in FSM

2003-11-25 Thread Arthur Ward
> "Arthur Ward" <[EMAIL PROTECTED]> writes: >> I was a bit stunned last night when I found this in the server logs for >> a >> 7.4RC2 installation: > >> Nov 24 20:37:18 x pg_autovacuum: [2003-11-24 08:37:18 PM] Performing: >> VACUUM ANALYZE "clients"."x" >> Nov 24 20:37:19 x postgres: [13904] PANIC

Re: [BUGS] inner query bug

2003-11-25 Thread Andrew Holm-Hansen
I tried copying the text of the patch into a file and running patch on it, but apparently I'm somehow impaired. Manually patched the relevant files, and it appears to be working just fine. Thanks for all your help, it was really much more than I expected. Andrew Holm-Hansen [EMAIL PROTECTED] On

Re: [BUGS] inner query bug

2003-11-25 Thread Tom Lane
Andrew Holm-Hansen <[EMAIL PROTECTED]> writes: > SC2test7=# select * from txstatus,tx txx where txstatus.txid = txx.txid > AND txstatus.statuschangetime = (select max(txstatus.statuschangetime) > from txstatus where txstatus.txid = txx.txid); FATAL: terminating > connection due to administrator co

Re: [BUGS] 7.4RC2 PANIC: insufficient room in FSM

2003-11-25 Thread Tom Lane
"Arthur Ward" <[EMAIL PROTECTED]> writes: > I was a bit stunned last night when I found this in the server logs for a > 7.4RC2 installation: > Nov 24 20:37:18 x pg_autovacuum: [2003-11-24 08:37:18 PM] Performing: > VACUUM ANALYZE "clients"."x" > Nov 24 20:37:19 x postgres: [13904] PANIC: insuffic

[BUGS] 7.4RC2 PANIC: insufficient room in FSM

2003-11-25 Thread Arthur Ward
I was a bit stunned last night when I found this in the server logs for a 7.4RC2 installation: Nov 24 20:37:18 x pg_autovacuum: [2003-11-24 08:37:18 PM] Performing: VACUUM ANALYZE "clients"."x" Nov 24 20:37:19 x postgres: [13904] PANIC: insufficient room in FSM Nov 24 20:37:19 x postgres: STATEME

Re: [BUGS] SELECT with MANY tables

2003-11-25 Thread Javier Carlos
Quoting Stephan Szabo <[EMAIL PROTECTED]>: > > On Mon, 24 Nov 2003, Javier Carlos wrote: > > > > > Please enter a FULL description of your problem: > > - > >When I make a SELECT with many tables (more than 12), postgresql eats > all my > > %CPU

Re: [BUGS] [PATCHES] (Modified) Patch request for PostgreSQL 7.4 for HP-UX

2003-11-25 Thread Peter Eisentraut
ViSolve Open Source Team writes: > 1. s_lock.h: modified with inline tas code for the HP-C compiler What is this line all about? +#if defined(__HP_aCC) || defined(__HP_cc) There are no other compilers supported, so this seems redundant. > 2. genbki.sh: a one-line change that fixes a string c