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

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
>