Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index

2004-01-09 Thread Tom Lane
Kragen Sitaker <[EMAIL PROTECTED]> writes: > We'll run the experiment again. Should we try 7.3.3 too? No, I don't think 7.3.3 is likely to behave differently from 7.3.4 as far as this goes. What would actually be interesting is whether you can make 7.4 fail. > Well, it's possible the daemon cou

Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index

2004-01-09 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Digging in the 7.3.2-to-7.3.4 change logs, I see one potentially > >> relevant change: > > > The only thing I can think of is the fix for splitting the first btree > > page. > > I paused on that too, but I don't

Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index

2004-01-09 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Digging in the 7.3.2-to-7.3.4 change logs, I see one potentially >> relevant change: > The only thing I can think of is the fix for splitting the first btree > page. I paused on that too, but I don't see how it could apply, unless the

Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index

2004-01-09 Thread Bruce Momjian
Tom Lane wrote: > Hmm. I'm not aware of any 7.4 bug fix that would affect such a thing, > so I wouldn't want to bet that 7.4 has really solved the issue. > > Digging in the 7.3.2-to-7.3.4 change logs, I see one potentially > relevant change: The only thing I can think of is the fix for splitting

Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index

2004-01-09 Thread Kragen Sitaker
On Sat, Jan 10, 2004 at 11:20:11AM +1100, Martijn van Oosterhout wrote: > Not really related to your problem, but given you're in a transaction, why > do you need to lock anything? What's wrong with: > > > The daemon that gets this error does the following every 15 seconds: > > - start a transacti

Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index

2004-01-09 Thread Kragen Sitaker
On Fri, Jan 09, 2004 at 06:19:00PM -0500, Tom Lane wrote: > Kragen Sitaker <[EMAIL PROTECTED]> writes: > > ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index > > We've been getting this error in our application every once in a while > > --- typically once an hour to

Re: [GENERAL] ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index

2004-01-09 Thread Martijn van Oosterhout
On Fri, Jan 09, 2004 at 12:07:25PM -0800, Kragen Sitaker wrote: Not really related to your problem, but given you're in a transaction, why do you need to lock anything? What's wrong with: > The daemon that gets this error does the following every 15 seconds: > - start a transaction > - delete th