On Fri, Jun 12, 2009 at 6:54 AM, Andrew Sullivan<ajs at crankycanuck.ca> wrote:
> On Fri, Jun 12, 2009 at 01:20:56PM +0530, Nagaraja, Madhukar (Madhukar) wrote:
>
>> switchover from the GUI, evrything seems quite ok. But when we
>> trying adding new entries from the GUI, we get a very vague PSQL
>> exception - duplicate entry primary key voilation.
>
> That doesn't sound vague to me.  It sounds like a perfectly clear
> message.  My bet is that you're tripping over a sequence value that
> is set too low or something like that.  But without seeing the actual
> exception message, instead of your vague description of it, I can't
> say more.

I would guess that a sequence isn't getting replicated and should be,
which is why you run in to the duplicate key issues after switching
nodes.

-Dave