Re: Unique constaint violated without being violated

["Dot Yet" <dot.yet@xxxxxxxxx>]

funny!! :) too bad, i also noticed it only after reading Merlin's response :)

On Sat, Dec 6, 2008 at 11:12 AM, Sebastian Tennant <sebyte@xxxxxxxxxxxxxxx> wrote:

Quoth "Merlin Moncure" <mmoncure@xxxxxxxxx>:

> 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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general