Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group