Re: Update violating constraint - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Update violating constraint
Date
Msg-id F8EE17FE-F48F-42FF-915E-686A8D546A13@seespotcode.net
Whole thread Raw
In response to Re: Update violating constraint  (Naz Gassiep <naz@mira.net>)
List 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



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Update violating constraint
Next
From: Andrei Kovalevski
Date:
Subject: Re: C functions under windows