Re: [BUGS] BUG #4913: Row missing from primary key index

2009-07-10 Thread Mathieu De Zutter
On Fri, Jul 10, 2009 at 6:24 PM, Tom Lane wrote: > As far as anyone knows, it's impossible to get into the > disconnected-backends state unless (a) you manually remove the > postmaster.pid file that provides the interlock against it, or > (b) you're trying to run multiple copies of Postgres on di

Re: [BUGS] BUG #4913: Row missing from primary key index

2009-07-10 Thread Mathieu De Zutter
On Fri, Jul 10, 2009 at 5:03 PM, Tom Lane wrote: > This could be checked by looking at the output of "ipcs -m" > (run this as root to be sure you get everything). > $ sudo ipcs -m -- Shared Memory Segments keyshmid owner perms bytes nattch statu

Re: [BUGS] BUG #4913: Row missing from primary key index

2009-07-10 Thread Mathieu De Zutter
On Fri, Jul 10, 2009 at 2:02 AM, Alvaro Herrera wrote: > What do the INSERT lines look like? Is it a trigger, an insert called > directly by the application? How is the sequence involved -- lastval(), > nextval(), does the code just leave the column out for the default to fire? > > * This is th

[BUGS] BUG #4913: Row missing from primary key index

2009-07-09 Thread Mathieu De Zutter
The following bug has been logged online: Bug reference: 4913 Logged by: Mathieu De Zutter Email address: math...@dezutter.org PostgreSQL version: 8.3.7 Operating system: Debian Lenny Description:Row missing from primary key index Details: I have a table log_event