count (*)

Started by alonsoover 18 years ago2 messagesgeneral
Jump to latest
#1alonso
test895@gmail.com

Hi,
I've got it, but I don't know the reason of it.
In the database table the records have duplicated and I've two rows for
every primary key - with different OIDs.
Is there any safe method to get rid of only one of each duplicated row?
Very strange however...

Thank you,
--
View this message in context: http://www.nabble.com/count-%28*%29-tf4440057.html#a12668226
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: alonso (#1)
Re: count (*)

alonso wrote:

I've got it, but I don't know the reason of it.
In the database table the records have duplicated and I've
two rows for
every primary key - with different OIDs.
Very strange however...

Very strange indeed.

Are you positive that there is a primary key constraint on
the column? Can you show some evidence?

Is there any safe method to get rid of only one of each
duplicated row?

If "id" is your "primary key":

DELETE FROM test USING test a
WHERE test.id = a.id AND test.oid > a.oid;

Yours,
Laurenz Albe