Re: How do I save data and then raise an exception?

I didn't see anything in the documentation about deferred constraints.
Can you point to someplace where I can read about them?

Thank you!

RobR

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, October 03, 2008 2:59 PM
To: Rob Richardson
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] How do I save data and then raise an exception?

On Fri, Oct 3, 2008 at 8:56 AM, Rob Richardson
<Rob(dot)Richardson(at)rad-con(dot)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.