Re: How do I save data and then raise an exception? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How do I save data and then raise an exception?
Date
Msg-id dcc563d10810031158k3f79c4acwec3a298701267f38@mail.gmail.com
Whole thread Raw
In response to Re: How do I save data and then raise an exception?  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Responses Re: How do I save data and then raise an exception?  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
List pgsql-general
On Fri, Oct 3, 2008 at 8:56 AM, Rob Richardson
<Rob.Richardson@rad-con.com> wrote:
> No, because the application first saves the coils and then saves the
> charge.  Setting up the foreign key constraint would prevent any coils
> from being saved because the charge record would never exist at the time
> the coil record was created.

You should be able to set your constraints to deferrable initially
deferred and get proper behaviour even with that update system.

pgsql-general by date:

Previous
From: "Rob Richardson"
Date:
Subject: Re: How do I save data and then raise an exception? -- solved
Next
From: Jörn Heid
Date:
Subject: Re: Standalone Windows Installation