RE: [GENERAL] Triggers: options besides compiled code? - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] Triggers: options besides compiled code?
Date
Msg-id F10BB1FAF801D111829B0060971D839F321578@cpsmail
Whole thread Raw
List pgsql-general
> > 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
> > choices limited to just (1) compiled code, and (2) the old rules
> > mechanism?
>
> if you insert a new row, isn't the sequence automatically inserted?
>
It is if you use table defaults.  (see 'create table', and 'netval()')
        -DEJ


pgsql-general by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] How to rename a database?
Next
From: "Antonio Garcia Mari"
Date:
Subject: Re: [GENERAL] What to do with no foreign keys