Re: last tuple affected

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: last tuple affected
Дата
Msg-id 20050127174136.GA23613@wolff.to
обсуждение исходный текст
Ответ на Re: last tuple affected  (Miguel Angel Tribaldos Hervas <mitriher@teleco.upv.es>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: pg_dump shell script with ~/.pgpass
Следующее
От: "Bruno Almeida do Lago"
Дата:
Сообщение: Oracle and PostgreSQL