OK, found it. I was trying to name a column with a keyword ('like'). The
error message threw me off. Sorry for the spam.Bill On 11/17/09 4:04 PM, "William Carithers" <wccarith...@lbl.gov> wrote: > I get an "Error: relation "boolean" does not exist when attempting to create > a table with columns of data type boolean. I using PostgreSQL 8.3.6 and the > docs say that it supports boolean data type and even show some create table > examples similar to mine. > > Sorry for such a newbie question but it's so simple that I'm stumped. > > Here's the terminal session: > quasar=# create table flags ( > plate integer, > mjd integer, > fiber integer, > redshift real, > class varchar(20), > core boolean, > bonus boolean, > midz boolean, > lohiz boolean, > neural boolean, > ukidds boolean, > kde boolean, > like boolean, > first boolean, > umag real, > gmag real, > rmag real, > imag real, > zmag real, > visual varchar(20)); > ERROR: relation "boolean" does not exist > > Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
