Re: Update violating constraint

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Naz Gassiep <naz(at)mira(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update violating constraint
Date: 2007-05-03 12:06:57
Message-ID: F8EE17FE-F48F-42FF-915E-686A8D546A13@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On May 2, 2007, at 23:36 , Naz Gassiep wrote:

> I don't
> know why you'd ever use your second option ever, as it virtually
> guarantees problems at a random point in your DB's growth.

There may be cases where the values are not all positive so you can't
use the -1 * technique, but the offset will work. It depends on the
nature of your data. One size doesn't necessarily fit all.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Tilles 2007-05-03 12:44:17 psql access of user's environmental variables
Previous Message Richard Huxton 2007-05-03 12:02:48 Re: Update violating constraint