Home > mailing lists

Thread: MESSAGE ERROR

MESSAGE ERROR

From

"Cornelio Royer Climent"

Date:

17 July 2010, 14:06:27

I want to create this table, but i can’t,

Look this error.

CREATE TABLE security_info2 (

window character varying(64) NOT NULL

);

ERROR: syntax error at or near "window"

LINE 2: window character varying(64) NOT NULL

Could any to help me, please?

I’m using postgresql 8.4

Thanks….

Re: MESSAGE ERROR

From

Leif Biberg Kristensen

Date:

17 July 2010, 14:19:35

On Saturday 17. July 2010 15.14.51 Cornelio Royer Climent wrote:
>
> Hi
>
>
>
> I want to create this table, but i can't,
>
>
>
> Look this error.
>
>
>
>
>
> CREATE TABLE security_info2 (
>
>     window character varying(64) NOT NULL
>
> );
>
> ERROR:  syntax error at or near "window"
>
> LINE 2:     window character varying(64) NOT NULL

"window" is a reserved word in PostgreSQL since version 8.3, I believe.

regards,
--
Leif Biberg Kristensen
http://solumslekt.org/blog/