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

Re: Table versions

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Table versions
Date: 2003-10-29 13:50:58
Message-ID: 1067435458.99917.34.camel@jester (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
> What I did next, is put a trigger on pg_attribute that should, in theory,
> on insert and update, fire up a function that will increment a version

System tables do not use the same process for row insertion / updates as
the rest of the system. You're trigger will rarely be fired.

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2003-10-29 14:30:50
Subject: Re: [SQL] Table versions
Previous:From: AlexDate: 2003-10-29 13:43:15
Subject: PG_DUMP Question

pgsql-sql by date

Next:From: Tom LaneDate: 2003-10-29 14:30:50
Subject: Re: [SQL] Table versions
Previous:From: StefDate: 2003-10-29 11:21:33
Subject: Re: [SQL] Table versions

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