Re: table named primary - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: table named primary
Date
Msg-id Pine.BSF.4.21.0104212317320.1183-100000@megazone23.bigpanda.com
Whole thread Raw
In response to table named primary  (Joseph Crawley <joseph@coscend.com>)
List 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.

pgsql-bugs by date:

Previous
From: Joseph Crawley
Date:
Subject: table named primary
Next
From: Thomas Lockhart
Date:
Subject: Re: TCL error with rserv on Solaris