Postgres Pro
Downloads
Home   >   mailing lists

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

From Dot Yet
Subject Re: Unique constaint violated without being violated
Date
Msg-id 93bc4af40812072102v13d49945j3bb3b11a14aa74ae@mail.gmail.com
Whole thread Raw
In response to Re: Unique constaint violated without being violated  (Sebastian Tennant <sebyte@smolny.plus.com>)
List pgsql-general
Tree view
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@smolny.plus.com> wrote:
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


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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner picking topsey turvey plan?
Next
From: "Gurjeet Singh"
Date:
Subject: Re: Monty on MySQL 5.1: "Oops, we did it again"