Re: [BUGS] BUG #2440: TEMP TABLES in Postgres 8.1.3

2006-05-16 Thread Tom Lane
"Peter Exner" <[EMAIL PROTECTED]> writes: > SQL-Statement: > UPDATE table1 SET value1 = value1 - (SELECT value1_sum FROM tmp_table WHERE > table1.table1_id = tmp_table.max_id) WHERE split_anteil < 1 AND afa_ende > = 24061 AND table1.table1_id = tmp_table.max_id; That's not standard SQL. You

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-16 Thread Andy
  I have removed the AV software and the problem doesn’t go away, it does seem to happen less frequently but is still there.  It is the same error -   “FATAL:  could not reattach to shared memory (key=5432001, addr=0196): Invalid argument”   The referenced key and address are alway

[BUGS]

2006-05-16 Thread google
> Could you provide a complete test case? As I've been told, there is no special code, just a usual sequence usage. There is no small part of code that can be reproduced. -- The situation is that there are 2 applications working with the same DB and accessing sequences. Each time application is s

[BUGS] BUG #2440: TEMP TABLES in Postgres 8.1.3

2006-05-16 Thread Peter Exner
The following bug has been logged online: Bug reference: 2440 Logged by: Peter Exner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 / 8.1.3 Operating system: SuSe Linux Description:TEMP TABLES in Postgres 8.1.3 Details: Hello, there is a problem with my

Re: [BUGS] BUG #2436: cannot --enable-thread-safety on -lpthread host

2006-05-16 Thread Paul Forgey
As given in my OS info, this isn't FC4. The configure script fails to enable threading in Debian Sarge. On May 15, 2006, at 6:48 AM, Tom Lane wrote: "Paul Forgey" <[EMAIL PROTECTED]> writes: Linux supplies -lpthread. The configure script seems to only look for -lpthreads and then give up