Re: [GENERAL] Error when creating table with boolean data type

2009-11-17 Thread Tom Lane
William Carithers writes: > OK, found it. I was trying to name a column with a keyword ('like'). The > error message threw me off. Sorry for the spam. FWIW, 8.4 and up will give you an error cursor on this: ERROR: relation "boolean" does not exist LINE 14: like boolean, ^ which

Re: [GENERAL] Error when creating table with boolean data type

2009-11-17 Thread APseudoUtopia
On Tue, Nov 17, 2009 at 7:15 PM, William Carithers wrote: > On 11/17/09 4:04 PM, "William Carithers" 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

Re: [GENERAL] Error when creating table with boolean data type

2009-11-17 Thread William Carithers
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" wrote: > I get an "Error: relation "boolean" does not exist when attempting to create > a table with columns of data type boole

[GENERAL] Error when creating table with boolean data type

2009-11-17 Thread William Carithers
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 s