Re: [BUGS] PERFORM bug with FOUND?

2003-11-22 Thread David Fetter
Tom Lane <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (David Fetter) writes: >> I've written a little hack, here included, which is supposed to find >> whether a user is in a group. I'd intended to do a PERFORM instead of >> SELECT INTO, but PERFORM appears to set FOUND to true no matter what. >

[BUGS] IpcSemaphoreCreate: semget(...) failed: No space left on device

2003-11-22 Thread jerry
I shortened the error msg to fit it into the subject box. I just completed a fresh install (not upgrade) of MDK 9.2 onto a 1.0 GHz Athlon with 512 MB of RAM. The PostgreSQL 7.3.4 RPMs were installed when I did the MDK 9.2 install, which also created the postgres account. The 'short version' for

Re: [BUGS] IpcSemaphoreCreate: semget(...) failed: No space left on device

2003-11-22 Thread GreyGeek
jerry wrote: > jerry wrote: > >> I shortened the error msg to fit it into the subject box. >> >> I just completed a fresh install (not upgrade) of MDK 9.2 onto a 1.0 GHz >> Athlon with 512 MB of RAM. The PostgreSQL 7.3.4 RPMs were installed when >> I did the MDK 9.2 install, which also created

Re: [BUGS] RC1 question of reloading data

2003-11-22 Thread jerry
Theodore Petrosky wrote: > So, I was logged on as postgres. but there is no > database called 'postgres' (or maybe I don't > understand the internals). Keep in mind that I am only > looking for understanding of the process... and I want > to make sure that doing this doesn't create problems > late

Re: [BUGS] 7.4: CHAR padding inconsistency

2003-11-22 Thread Troels Arvin
On Wed, 19 Nov 2003 14:50:24 -0500, Bruce Momjian wrote: > Anyway, what did you want it to output? "AAA hey"? We could do > that, but I assume most people wouldn't expect that output? I certainly depends on their background. Personally, the padding characteristics of the CHAR type was one

[BUGS] memory bug

2003-11-22 Thread Alex Albarracin
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 space. Do you know if postgres uses some disk spac

Re: [BUGS] IpcSemaphoreCreate: semget(...) failed: No space left on device

2003-11-22 Thread jerry
jerry wrote: > I shortened the error msg to fit it into the subject box. > > I just completed a fresh install (not upgrade) of MDK 9.2 onto a 1.0 GHz > Athlon with 512 MB of RAM. The PostgreSQL 7.3.4 RPMs were installed when > I did the MDK 9.2 install, which also created the postgres account. >

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

2003-11-22 Thread kchen
Version: Release 7.4 (production) Error message: psql: FATAL: unrecognized configuration parameter "show_statement_stats" This is reproducible if start the engine with option "-o -s". (defined in src/backend/tcop/postgres.c) My command to start engine is: nohup /app/pgsql/7.4/bin/postmaster -

[BUGS] inner query bug

2003-11-22 Thread Andrew Holm-Hansen
I was advised to send an e-mail after a discussion with neilc on #postgresql. The failure occurs randomly, never on the first time (at least that I've seen) and usually only after doing a bunch of other stuff first (big joins, views, etc). In one case, the backend terminated and restarted, this ha

[BUGS] Bug Report

2003-11-22 Thread Douglas M. Westfall
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the problem

[BUGS] (Modified) Patch request for PostgreSQL 7.4 for HP-UX IA-64

2003-11-22 Thread ViSolve Open Source Team
Subject: PostgreSQL Patch: Modified Test-and-set routine for HP-UX (IA-64) specifically for the HP-C compiler   With reference to Tom Lane's response to our previous patch request  (at http://archives.postgresql.org/pgsql-bugs/2003-10/msg00149.php)this is a modified and more focussed patch re

Re: [BUGS] Bug Report

2003-11-22 Thread Douglas M. Westfall
Yes, I have searched the archives, and searches for 'inet' or 'ilike' or 'inet+ilike' and 'inet&ilike' return 0 results each. Have I missed something? Regards, DougW On Thu, 2003-11-20 at 23:09, Douglas M. Westfall wrote: > If PostgreSQL failed to compile on your computer or you found a bug tha