Re: [GENERAL] serial type (text instead of integer) and duplicate keys

2005-04-12 Thread Carlos Costa
. On Apr 12, 2005 2:00 PM, Richard Huxton wrote: > Carlos Costa wrote: > > Hello all! > > > > There is an extrange error in my logfile: > > > > update articles set online='t' where id = 391 ; > > ERROR: duplicate key violates unique constraint

[GENERAL] serial type (text instead of integer) and duplicate keys

2005-04-12 Thread Carlos Costa
Hello all! There is an extrange error in my logfile: update articles set online='t' where id = 391 ; ERROR: duplicate key violates unique constraint "articles_pkey" (the error exists only with this id) I've checked (well, almost imposible) if there was more than one article with this id: sele

Re: [GENERAL] Problem with the sequence

2005-02-03 Thread Carlos Costa
I wrote a very basic entry about this at improveyourweb some weeks ago (http://www.improveyourweb.com/?q=node/2). Hope it helps. In the source code, sequence.c, you can read something like: /* * Decide whether we should emit a WAL log record. If so, force up * the fetc