Re: create snapshot? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: create snapshot?
Date
Msg-id Pine.LNX.4.21.0011241801110.791-100000@peter.localdomain
Whole thread Raw
In response to Re: create snapshot?  (hubert depesz lubaczewski <depesz@depesz.pl>)
List 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@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: "David Reid"
Date:
Subject: Curreny symbol
Next
From: Tom Lane
Date:
Subject: Re: Hung backends