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

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Roland Roberts <roberts(at)panix(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] Triggers: options besides compiled code?
Date: 1998-07-15 17:57:47
Message-ID: F10BB1FAF801D111829B0060971D839F333165@cpsmail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Check out the contrib/refint.* in the distribution. I believe it
handles CASCADE DELETE.
-DEJ

> -----Original Message-----
> From: Roland Roberts [SMTP:roberts(at)panix(dot)com]
> Sent: Sunday, July 12, 1998 3:00 PM
> To: pgsql-general(at)postgreSQL(dot)org
> Subject: Re: [GENERAL] Triggers: options besides compiled code?
>
> >>>>> "dej" == Jackson, DeJuan <djackson(at)cpsgroup(dot)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(at)lscorp(dot)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(at)panix(dot)com
>

Browse pgsql-general by date

  From Date Subject
Next Message Steve Doliov 1998-07-15 19:05:28 Re: [GENERAL] Different dB dir
Previous Message Jason 1998-07-15 17:52:26 Different dB dir