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

2005-04-12 Thread Tom Lane
Carlos Costa <[EMAIL PROTECTED]> writes: > SELECT oid,xmin,xmax,ctid,id FROM articles WHERE id=391; >oid | xmin| xmax| ctid | id > -+---+---+--+- > 3032469 | 152691945 | 152886684 | (104,6) | 391 > 3032469 | 152886687 | 156995994 | (104,1

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

2005-04-12 Thread Carlos Costa
Thank you very much. Here is the output: SELECT oid,xmin,xmax,ctid,id FROM articles WHERE id=391; oid | xmin| xmax| ctid | id -+---+---+--+- 3032469 | 152691945 | 152886684 | (104,6) | 391 3032469 | 152886687 | 156995994 | (104,13) | 391

[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