Re: almost there on a design

Is it possible to do 'cross constraints' between two tables using a transaction and:

SETCONSTRAINTSALLDEFERRED;

Or making both tables INITIALLY DEFERRED?

3/3/2003 12:54:17 PM, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:

>
>On Mon, 3 Mar 2003, Dennis Gearon wrote:
>
>> 3/3/2003 10:25:12 AM, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:
>>
>> If I create the necessary fields first in this order, no deferrment seems necessary:
>>
>> I'm thinking about trying to create a user which only has access to selects and stored
>> procedures, so the web interface can ONLY use functions which take place in a transaction and
>> take care of it that way.
>>
>> create an email,
>> create a usr
>> create a usr email.
>
>That'll work from a function (currently), but from straight commands,
>if you make it such that there must be a usremailaddrs row to make a usr,
>then the second will fail. If you try to make the usremailaddrs row
>first, it fails due to the foreign key.
>
>