Re: [BUGS] 7.4: FATAL: unrecognized configuration parameter "show_statement_stats"

2003-11-24 Thread Tom Lane
[EMAIL PROTECTED] writes: > Version: Release 7.4 (production) > Error message: psql: FATAL: unrecognized configuration parameter > "show_statement_stats" Looks like Bruce missed a couple places while renaming those config variables :-(. It's fixed in CVS tip, but the best workaround for the mome

Re: [BUGS] memory bug

2003-11-24 Thread Neil Conway
"Alex Albarracin" <[EMAIL PROTECTED]> writes: > Hello, i have a problem related to the partition memory where > postgres is installed, this has increased so much that the partition > is full and postgres can not start up. The message postmaster sends > when i want to restart is insuficient disk spa

[BUGS] Fwd: Solaris build of 7.4 problem with --enable-thread-safety

2003-11-24 Thread Seum-Lim Gan
Title: Fwd: Solaris build of 7.4 problem with --enable-thread Date: Mon, 24 Nov 2003 10:11:15 -0600 To: [EMAIL PROTECTED] From: Seum-Lim Gan <[EMAIL PROTECTED]> Subject: Solaris build of 7.4 problem with --enable-thread-safety Cc: Josh Berkus <[EMAIL PROTECTED]> Bcc: X-Attachments: Hi Josh, Is

[BUGS] String index out of range - Postgresql 7.3.4, Resin & JDBC

2003-11-24 Thread Antony Brooke-Wood
Title: Message HI,   We are getting the following error through a JSP.   We received the same error for both 7.3.1 through 7.3.4 and several JDBC driver changes (currently running the latest).   The strange thing is that this actual page was working fine, then, after we modified a different

[BUGS] SELECT with MANY tables

2003-11-24 Thread Javier Carlos
POSTGRESQL BUG REPORT TEMPLATE Your name: F. Javier Carlos Rivera Your email address :

Re: [BUGS] SELECT with MANY tables

2003-11-24 Thread Stephan Szabo
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 and I've waited more than 1 hour and stays the same. The weir

Re: [BUGS] Fwd: Solaris build of 7.4 problem with --enable-thread-safety

2003-11-24 Thread Peter Eisentraut
Seum-Lim Gan writes: > >make[4]: Entering directory > >`/n/DBMS/edbteam/src/sol8/sparc64/postgresql-7.4/src/interfaces/ecpg/ecpglib' > >/opt/SUNWspro6.2/SUNWspro/bin/cc -Xa -G -h libecpg.so.4 execute.o > >typename.o descriptor.o data.o error.o prepare.o memory.o connect.o > >misc.o -L../../../../s

Re: [BUGS] inner query bug

2003-11-24 Thread Neil Conway
Tom Lane <[EMAIL PROTECTED]> writes: > What PG version is this? We've fixed a number of bugs with that > symptom, IIRC ... When we were discussing this on IRC, I made sure to check it was a recent version of PG -- I believe it is 7.4.0. The last reported instance I could see of a bug with this sy

Re: [BUGS] inner query bug

2003-11-24 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > When we were discussing this on IRC, I made sure to check it was a > recent version of PG -- I believe it is 7.4.0. The last reported > instance I could see of a bug with this symptom was for 7.4 beta 1 (at > which point we thought we'd fixed it). Yeah, I

Re: [BUGS] SELECT with MANY tables

2003-11-24 Thread Stephan Szabo
On Mon, 24 Nov 2003, Javier Carlos wrote: > 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 ma

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

2003-11-24 Thread Klint Gore
On Sun, 23 Nov 2003 22:48:17 -0800 (PST), Stephan Szabo <[EMAIL PROTECTED]> wrote: > On Mon, 24 Nov 2003, Klint Gore wrote: > > > I've got the message "ERROR: variable not found in subplan target lists" > > when I have a union between 2 views. Both selects from the views run > > without the unio

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

2003-11-24 Thread Klint Gore
On Tue, 25 Nov 2003 11:39:03 +1100, Klint Gore <[EMAIL PROTECTED]> wrote: > On Sun, 23 Nov 2003 22:48:17 -0800 (PST), Stephan Szabo <[EMAIL PROTECTED]> wrote: > > On Mon, 24 Nov 2003, Klint Gore wrote: > > > > > I've got the message "ERROR: variable not found in subplan target lists" Had a quick

[BUGS] unix_socket_directory vs pg_ctl?

2003-11-24 Thread Szűcs Gábor
Dear Gurus, POSTGRESQL BUG REPORT TEMPLATE Your name : Gabor Szucs Your email address : [EMAIL PROTECTED] System Co

Re: [BUGS] Fwd: Solaris build of 7.4 problem with

2003-11-24 Thread Seum-Lim Gan
Hi Peter, I got the output from the cc verbose (-#). Looks like there is a "-hread" towards the end. Thanks. Gan /opt/SUNWspro6.2/SUNWspro/bin/cc -# -Xa -G -h libecpg.so.4 execute.o typename.o descriptor.o data.o error.o prepare.o memory.o connect.o misc.o -L../../../../src/port -L../pgtypesli