Re: create snapshot? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: create snapshot?
Date
Msg-id 20001124154307.B7157@gruby
Whole thread Raw
In response to create snapshot?  (hubert depesz lubaczewski <depesz@depesz.pl>)
Responses Re: create snapshot?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
On Fri, Nov 24, 2000 at 11:23:41AM -0000, Alistair Hopkins wrote:
> assuming users are logging on as psqluser but the db is owned by psqlowner:
> create table mysnapshot as select * from myuser;
> grant select on mysnapshot to psqluser;

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;

depesz

--
hubert depesz lubaczewski
------------------------------------------------------------------------
     najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
      jest niesamowita wręcz łatwość unikania kontaktów z nim ...

pgsql-general by date:

Previous
From: "Jarmo Paavilainen"
Date:
Subject: SV: Table whose name has Capital letters
Next
From: Peter Eisentraut
Date:
Subject: Re: pgaccess