Re: last tuple affected - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: last tuple affected
Date
Msg-id 20050127174136.GA23613@wolff.to
Whole thread Raw
In response to Re: last tuple affected  (Miguel Angel Tribaldos Hervas <mitriher@teleco.upv.es>)
List pgsql-general
On Thu, Jan 27, 2005 at 12:45:13 +0100,
  Miguel Angel Tribaldos Hervas <mitriher@teleco.upv.es> wrote:
>
> I only need to know if a table has changed since the last check
> (create, update...), but I want to avoid a trigger + artificial records table.
> Is this information recorded somewhere, in a system table perhaps?
> What about a hash value refered to any table?

Remember there are different versions of tables that exist at the same time.
If you really want to do the above, you will need to serialize access.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: pg_dump shell script with ~/.pgpass
Next
From: "Bruno Almeida do Lago"
Date:
Subject: Oracle and PostgreSQL