Re: create snapshot?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: create snapshot?
Date: 2000-11-24 17:02:15
Message-ID: Pine.LNX.4.21.0011241801110.791-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski writes:

> o.k. but updating it requires to drop table, and recreate using full select.
> and i want it to work like:
>
> update snapshot mysnapshot;
> done;

Write update rules or triggers on the snapshot table, and write a stored
procedure to encapsulate the "update snapshot" part.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Schmidt, Peter 2000-11-24 17:02:42 RE: Hung backends
Previous Message David Reid 2000-11-24 16:41:47 Curreny symbol