Thread

1. table named primary

   Joseph Crawley <joseph@coscend.com> — 2001-04-20T00:10:49Z

   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".
   thanks
   Joseph Crawley
   
   
   

2. Re: table named primary

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2001-04-22T06:20:26Z

   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.