Re: [SQL] how to vacum

2003-09-10 Thread Martin Marques
El Mié 10 Sep 2003 10:07, Bruno Wolff III escribió: > On Wed, Sep 10, 2003 at 20:43:25 +0800, > > Richard Sydney-Smith <[EMAIL PROTECTED]> wrote: > > Tried to issue the command "vacum full" both from psql and the sql box in > > pgadmin without success. > > > > How do you use the command? > > > >

Re: [SQL] how to vacum

2003-09-10 Thread Peter Eisentraut
Richard Sydney-Smith writes: > Tried to issue the command "vacum full" both from psql and the sql box in pgadmin > without success. vacuum full; ^^ -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will igno

Re: [SQL] how to vacum

2003-09-10 Thread Erik Thiele
On Wed, 10 Sep 2003 20:43:25 +0800 "Richard Sydney-Smith" <[EMAIL PROTECTED]> wrote: > Tried to issue the command "vacum full" both from psql and the sql box in pgadmin > without success. seems like you also vacuumed the second 'U' out of the word :) vacuum full; does the trick. cya erik

Re: [SQL] how to vacum

2003-09-10 Thread Bruno Wolff III
On Wed, Sep 10, 2003 at 20:43:25 +0800, Richard Sydney-Smith <[EMAIL PROTECTED]> wrote: > Tried to issue the command "vacum full" both from psql and the sql box in pgadmin > without success. > > How do you use the command? > > select vacum full; > > also does not work Try using: vacuum full

Re: [SQL] [JDBC] contrib/ltree

2003-09-10 Thread Barry Lind
I would recommend using getString()/setString(). You will need to marshall the data into the correct format, but you will at least be able to get and set the values. --Barry [EMAIL PROTECTED] wrote: how do i get jdbc to recognize the ltree type that comes with the contrib/ltree extension? This

Re: [SQL] MINUS & ROWNUM in PostGres

2003-09-10 Thread A.Bhuvaneswaran
> Anyway, you'll need to write your own replace() if you stick with that > release. > You can use this replace function, if you stick with that release. regards, bhuvaneswaran create or replace function replace (varchar, varchar, varchar) returns varchar as ' declare string alias for

[SQL] how to vacum

2003-09-10 Thread Richard Sydney-Smith
Tried to issue the command "vacum full" both from psql and the sql box in pgadmin without success.   How do you use the command?   select vacum full;   also does not work   Lost in the woods please help   Richard