Re: table named primary

Stephan Szabo <sszabo@megazone23.bigpanda.com>

From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Joseph Crawley <joseph@coscend.com>
Cc: pgsql-bugs@postgresql.org
Date: 2001-04-22T06:20:26Z
Lists: pgsql-bugs
On Thu, 19 Apr 2001, Joseph Crawley wrote:

> I'm not sure if this is a bug or feature but in ver7.1 on linux you 
> can't have a column name "primary".

Probably because it's a reserved word as part of PRIMARY KEY.
Actually if you double quote the name everywhere you use it, it'll
probably work, but that's probably a bad idea in general.