Re: Erro - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Erro
Date
Msg-id 20040503222914.Y26988@megazone.bigpanda.com
Whole thread Raw
In response to Erro  (Aldrey Galindo <aldreygalindo@yahoo.com.br>)
List pgsql-bugs
On Wed, 28 Apr 2004, [iso-8859-1] Aldrey Galindo wrote:

> Hi,
>    Would like to report a problem that happened with a
> friend mine.  I was to inquire and I found the
> following one.
>
> --
> db=# create table teste (desc varchar(50));
> ERROR:  parser: parse error at or near "desc" at
> character 21
> db=# create table table (teste varchar(50));
> ERROR:  parser: parse error at or near "table" at
> character 14

DESC and TABLE are reserved words in SQL, so you need to double
quote them to use them as column or table names.

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: BUG #1145: silent REVOKE failures
Next
From: Sean Chittenden
Date:
Subject: Re: [GENERAL] cache lookup of relation 165058647 failed