From: | "Dot Yet" <dot(dot)yet(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unique constaint violated without being violated |
Date: | 2008-12-08 05:02:27 |
Message-ID: | 93bc4af40812072102v13d49945j3bb3b11a14aa74ae@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)smolny(dot)plus(dot)com>wrote:
> Quoth "Merlin Moncure" <mmoncure(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2008-12-08 05:54:25 | Re: Monty on MySQL 5.1: "Oops, we did it again" |
Previous Message | Tom Lane | 2008-12-08 02:02:11 | Re: Planner picking topsey turvey plan? |