Check out the contrib/refint.* in the distribution. I believe it
handles CASCADE DELETE.
-DEJ
> -----Original Message-----
> From: Roland Roberts [SMTP:roberts@panix.com]
> Sent: Sunday, July 12, 1998 3:00 PM
> To: pgsql-general@postgreSQL.org
> Subject: Re: [GENERAL] Triggers: options besides compiled code?
>
> >>>>> "dej" == Jackson, DeJuan <djackson@cpsgroup.com> 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 <lynch@lscorp.com> had sent me the
> same information via email. I was unaware of the "default" clause
> which certainly makes this piece easier.
>
> I guess I'm still stuck with writing C-code to get cascading deletes,
> but I can probably postpone that requirement for a while....
>
> Thanks,
>
> roland
> --
> Roland B. Roberts
> roberts@panix.com
>