I don't believe that you need a trigger to do this. When you create a table that will use an
"id"
sequence, you would simply define its datatype as a serial or bigserial. In the background, it
will automatically create a sequence for you and it will automatical set you id column's default
valve to "nextval("your_new_sequence"). when you insert rows into your new table, simply allow
your table to use its default value to give you the next value in you sequence.
see http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL for an example.
Regards,
Richard
--- Lan Barnes <lan@falleagle.net> wrote:
> My desire is to have a table auto update an "id" sequence on every
> insert, relieving the front end program of the responsibility.
>
> I've never written a trigger. I imagine that there may be a contrib
> trove of them.
>
> There may also be an easier way to approach the problem. Please feel
> free to refer me to books or web sites.
>
> TIA,
>
> --
> Lan Barnes lan@falleagle.net
> Linux Guy, SCM Specialist 858-354-0616
> Tcl/Tk Enthusiast
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>