Re: table named primary

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Joseph Crawley <joseph(at)coscend(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: table named primary
Date: 2001-04-22 06:20:26
Message-ID: Pine.BSF.4.21.0104212317320.1183-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Lockhart 2001-04-22 06:31:04 Re: TCL error with rserv on Solaris
Previous Message Peter Eisentraut 2001-04-21 11:06:06 Re: pg_ctl restart bug