| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Miguel Angel Tribaldos Hervas <mitriher(at)teleco(dot)upv(dot)es> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: last tuple affected |
| Date: | 2005-01-27 17:41:36 |
| Message-ID: | 20050127174136.GA23613@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 27, 2005 at 12:45:13 +0100,
Miguel Angel Tribaldos Hervas <mitriher(at)teleco(dot)upv(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Schnoor | 2005-01-27 17:47:07 | Moving from Sybase to PostgreSQL - Stored Procedures |
| Previous Message | Bruno Almeida do Lago | 2005-01-27 17:32:38 | Oracle and PostgreSQL |