Postgres Pro
Downloads
Home   >   mailing lists

Re: Error when creating table with boolean data type - Mailing list pgsql-general

From Tom Lane
Subject Re: Error when creating table with boolean data type
Date
Msg-id 9390.1258514144@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error when creating table with boolean data type  (William Carithers <wccarithers@lbl.gov>)
List pgsql-general
Tree view 
William Carithers <wccarithers@lbl.gov> 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 doesn't directly say that "like" is the problem but might at least
help a little bit.

            regards, tom lane

pgsql-general by date:

Previous
From: "Naoko Reeves"
Date:
Subject: Where do you store key for encryption
Next
From: Merlin Moncure
Date:
Subject: Re: Where do you store key for encryption