Re: [GENERAL] Vacuumdb error

2011-04-14 Thread Vidhya Bondre
Gipsz, We got this error too what we did is ran vacuum analyze verbose and afterthat reindexed the db and we din't see the error croping again. Regards Vidhya On Thu, Apr 14, 2011 at 5:26 PM, Gipsz Jakab wrote: > Dear List, > > Today morning at 01:00 AM in our PostgreSQL 9.0.3 server a routine

Re: [GENERAL] column does not exist error

2009-11-18 Thread Vidhya Bondre
Can you try reframing it as : SELECT title FROM node WHERE type='client; Regards Vidhya On Wed, Nov 18, 2009 at 6:53 PM, Dave Coventry wrote: > Tearing my hair out, can anyone see what I'm doing wrong? > > SELECT title FROM node WHERE type=client; > > ERROR: column "client" does not exist

Re: [GENERAL] Creating new database

2009-11-18 Thread Vidhya Bondre
can you specify the exact commands and the sequence. With this set up it should work. how do you import the data. Vidhya On Wed, Nov 18, 2009 at 5:18 PM, Malcolm Warren wrote: > Dear All, > > > I've been using a single database for many years. > I'd now like to create a new separate database wi