Обсуждение: MESSAGE ERROR

Поиск
Список
Период
Сортировка

MESSAGE ERROR

От
"Cornelio Royer Climent"
Дата:

 

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

 

 

 

Could any to help me, please?

 

I’m using postgresql 8.4

 

Thanks….

 

 

Re: MESSAGE ERROR

От
Leif Biberg Kristensen
Дата:
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/