From: | Miguel Angel Tribaldos Hervas <mitriher(at)teleco(dot)upv(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: last tuple affected |
Date: | 2005-01-27 11:45:13 |
Message-ID: | 1106826313.41f8d449a07e4@webmail.upv.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Thanks.
>>Miguel Angel Tribaldos Hervas wrote:
>> Hi all!
>>
>> Two related questions about a problem i'm trying to solve:
>> How can I know the last tuple affected by an insert/update operation per
>> table??
>> Is there exists any function in Postgres for retrieving some hash
>> value from a table??
>
>You don't define what you mean by "last", and it's not a simple thing.
>You could attach triggers to the tables and have them record changes.
>
>Perhaps tell us what you are trying to do, rather than how you want to
>do it.
>--
> Richard Huxton
> Archonet Ltd
>--
From | Date | Subject | |
---|---|---|---|
Next Message | Max | 2005-01-27 11:51:59 | |
Previous Message | Richard Huxton | 2005-01-27 11:34:18 | Re: last tuple affected |