[ADMIN] Restoring a tablespace

2007-07-04 Thread Martin Arpon
Hi, I have a filesystem backup (cold - database was not running) of only a single tablespace where the database was sitting. Is it possible to install a new instance of PostgreSQL and in some way "re-mount" this tablespace recovering the database that was there? The whole database was there, and

Re: [ADMIN] alter sequence in a function

2007-07-04 Thread John DeSoi
On Jul 3, 2007, at 6:48 PM, Julio Leyva wrote: create or replace function updatesafe() returns integer AS $$ DECLARE maxseq integer; alterseq varchar(256); thumb integer; newvalue integer; BEGIN newvalue := 10010; maxseq := (select max(safeoperationid) from safeopencloseoperation); if (