Re: Unique constaint violated without being violated

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
>

In response to

Browse pgsql-general by date

  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?