Re: Primary key violation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Primary key violation
Date
Msg-id 29783.1051302766@sss.pgh.pa.us
Whole thread Raw
In response to Primary key violation  (bmp@ipath.net.in)
List pgsql-bugs
bmp@ipath.net.in writes:
> We were using postgresql for our development for two years. The database which we are using is having no problem till
lastweek.Now we are using version 7.2 of postgresql. 

If you are still on 7.2, and not 7.2.4, you should update.  Immediately.

> In this week, we got two major bugs in database. They are,

Did you have any system or database crashes before that?  These sound
like the kind of thing you could get after a crash, or an attempt to
backup/restore a live database using tar, or something else that would
allow files to get out of sync.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Shift-Enter = Segmentation Fault
Next
From: Tom Lane
Date:
Subject: Re: parallel pg installation and functions gotcha