RE: [GENERAL] Triggers: options besides compiled code?

1998-07-15 Thread Jackson, DeJuan
Check out the contrib/refint.* in the distribution. I believe it handles CASCADE DELETE. -DEJ > -Original Message- > From: Roland Roberts [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, July 12, 1998 3:00 PM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Tr

Re: [GENERAL] Triggers: options besides compiled code?

1998-07-12 Thread Roland Roberts
> "dej" == Jackson, DeJuan <[EMAIL PROTECTED]> writes: >> if you insert a new row, isn't the sequence automatically >> inserted? >> dej> It is if you use table defaults. (see 'create table', and dej> 'netval()') Thanks for the tip; Richard Lynch <[EMAIL PROTECTED]> had

RE: [GENERAL] Triggers: options besides compiled code?

1998-07-10 Thread Jackson, DeJuan
> > I started to look at the triggers documentation and was immediately > > dismayed to discover that I would have compile code to create a > > trigger. I have been using the old "rules" mechanism to > automatically > > put a sequence number into a tuple when inserting new rows. Are my > > choic

Re: [GENERAL] Triggers: options besides compiled code?

1998-07-09 Thread Brian
On 9 Jul 1998, Roland Roberts wrote: > I started to look at the triggers documentation and was immediately > dismayed to discover that I would have compile code to create a > trigger. I have been using the old "rules" mechanism to automatically > put a sequence number into a tuple when inserting