Skip site navigation (1) Skip section navigation (2)

Triggering a table id from a sequence

From: Lan Barnes <lan(at)falleagle(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Triggering a table id from a sequence
Date: 2006-04-10 23:53:27
Message-ID: 20060410235327.GA22503@falleagle.net (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)falleagle(dot)net
Linux Guy, SCM Specialist     858-354-0616
Tcl/Tk Enthusiast 

Responses

pgsql-novice by date

Next:From: meDate: 2006-04-11 00:55:10
Subject: Re: PostgreSQL a slow DB?
Previous:From: operationsengineer1Date: 2006-04-10 23:47:46
Subject: Re: PostgreSQL a slow DB?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group