Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique constaint violated without being violated - Mailing list pgsql-general

From Sebastian Tennant
Subject Re: Unique constaint violated without being violated
Date
Msg-id myf9qo3z.fsf@vps203.linuxvps.org
Whole thread Raw
In response to Unique constaint violated without being violated  (Sebastian Tennant <sebyte@smolny.plus.com>)
Responses Re: Unique constaint violated without being violated
List pgsql-general
Tree view 
Quoth "Merlin Moncure" <mmoncure@gmail.com>:
> It looks to me like you are setting the whole table to the same
> address in the update statement (no where clause)...so of course you'd
> get the error.  Maybe you want to do an insert statement?
>
> merlin

Doh!  Thanks Merlin.  I'm so glad it's just my mind that's going! :-)

Sebastian

pgsql-general by date:

Previous
From: Sebastian Tennant
Date:
Subject: Re: Resp.: Automatic insert statement generator?
Next
From: Raymond O'Donnell
Date:
Subject: Re: Resp.: Automatic insert statement generator?