Re: [GENERAL] vacuum full for all databases

2004-09-02 Thread Oleg Bartunov
On Thu, 2 Sep 2004, Richard Huxton wrote: > Ilia Chipitsine wrote: > > Dear Sirs > > > > I'm about to write plpgsql function which will "vacuum full" all existing > > databases. Below is an example how to get list of databases. > > > > What should I write instead of "raise notice" ? > > > raise

Re: [GENERAL] vacuum full for all databases

2004-09-02 Thread Ilia Chipitsine
> Ilia Chipitsine wrote: > > Dear Sirs > > > > I'm about to write plpgsql function which will "vacuum full" all existing > > databases. Below is an example how to get list of databases. > > > > What should I write instead of "raise notice" ? > > > raise notice ''datname = %'',list.datname; > > So

Re: [GENERAL] vacuum full for all databases

2004-09-02 Thread Richard Huxton
Ilia Chipitsine wrote: Dear Sirs I'm about to write plpgsql function which will "vacuum full" all existing databases. Below is an example how to get list of databases. What should I write instead of "raise notice" ? raise notice ''datname = %'',list.datname; Something like: EXECUTE ''VACUUM FU

Re: [GENERAL] vacuum full for all databases

2004-09-02 Thread Peter Eisentraut
Am Donnerstag, 2. September 2004 09:32 schrieb Ilia Chipitsine: > I'm about to write plpgsql function which will "vacuum full" all existing > databases. Below is an example how to get list of databases. > > What should I write instead of "raise notice" ? You normally cannot access different databa

[GENERAL] vacuum full for all databases

2004-09-02 Thread Ilia Chipitsine
Dear Sirs I'm about to write plpgsql function which will "vacuum full" all existing databases. Below is an example how to get list of databases. What should I write instead of "raise notice" ? CREATE OR REPLACE FUNCTION vacuum_all() RETURNS integer AS ' DECLARE query text; list RECORD;