Re: [BUGS] BUG #1173: Sig 11 in insert

2004-06-20 Thread Tomi Orava
Tom Lane wrote: "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: It seems that MnoGoSearch 3.2.17 is capable of crashing postgresql 7.4.2 repeatedly every once in a while on Amd Athlon/Fedora Core 2. The gdb trace: This isn't super helpful since some of the passed arguments are evidently clob

Re: [BUGS] Hangs on Semop

2004-06-20 Thread Tom Lane
"Gary Mensenares" <[EMAIL PROTECTED]> writes: > I was just wondering if anyone else here has ever experienced Postgres > hanging on an INSERT or DELETE command? Sounds to me like it's waiting for somebody else's lock. The pg_locks system view might help clue you into which lock.

[BUGS] Hangs on Semop

2004-06-20 Thread Gary Mensenares
Hello all!   I was just wondering if anyone else here has ever experienced Postgres hanging on an INSERT or DELETE command?   Here is my setup: DB:   Postgres 7.3.4 OS:  Fedora Core 1 Kernel:  2.4.22   The behavior is quite erratic. Using the exact same test script, sometim

Re: [BUGS] BUG #1167: POSIX getpwuid_r 4arg vs 5arg issue

2004-06-20 Thread Jim Helm
Thanks. I wish I had seen it earlier myself. I've been busy on other projects and haven't been following the 7.4.X releases. Doesn't hurt me any, since I was able to just build without thread support, but I thought it would be good for other to know about it. Thanks again - for this, and all the

Re: [BUGS] BUG #1169: Select table.oid from view seems to loop

2004-06-20 Thread Robert Osowiecki
Richard Huxton wrote: In 7.4 there is a postgresql.conf setting to control this behaviour (add_missing_from). I'd turn it off, as I've always found it to cause problems rather than solve them. I agree :) PG now reports "ERROR: missing from clause", I've added "table1.oid" do view definition and

Re: [BUGS] [Fwd: Bug#255208: postgresql - ignores SIGPIPE]

2004-06-20 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> writes: > The postgres daemon ignores SIGPIPE. This is not a bug; it's intentional. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? ht

[BUGS] [Fwd: Bug#255208: postgresql - ignores SIGPIPE]

2004-06-20 Thread Oliver Elphick
This seems a reasonable request. Is it possible? -Forwarded Message- From: Bastian Blank <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Bug#255208: postgresql - ignores SIGPIPE Date: Sat, 19 Jun 2004 16:52:04 +0200 Package: postgresql Version: 7.4.3-1 Severity: important The postgre