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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-10-29 14:30:50 Re: [SQL] Table versions
Previous Message Stef 2003-10-29 11:21:33 Re: [SQL] Table versions