Re: [GENERAL] syntax error foreign key

2005-08-16 Thread Joshua D. Drake
Matthew Terenzio wrote: On Aug 16, 2005, at 9:37 PM, Matthew Terenzio wrote: db=# ALTER TABLE ONLY table ADD CONSTRAINT "$1" FOREIGN KEY (user) REFERENCES users(user_id); ERROR: syntax error at or near "user" at character 56 I'm either blind or something besides syntax can cause this error

Re: [GENERAL] syntax error foreign key

2005-08-16 Thread Douglas McNaught
Matthew Terenzio <[EMAIL PROTECTED]> writes: > On Aug 16, 2005, at 9:37 PM, Matthew Terenzio wrote: > >> db=# ALTER TABLE ONLY table ADD CONSTRAINT "$1" FOREIGN KEY (user) >> REFERENCES users(user_id); >> ERROR: syntax error at or near "user" at character 56 >> >> I'm either blind or something be

Re: [GENERAL] syntax error foreign key

2005-08-16 Thread Michael Fuhr
On Tue, Aug 16, 2005 at 10:09:14PM -0400, Matthew Terenzio wrote: > >db=# ALTER TABLE ONLY table ADD CONSTRAINT "$1" FOREIGN KEY (user) > >REFERENCES users(user_id); > >ERROR: syntax error at or near "user" at character 56 > > > >I'm either blind or something besides syntax can cause this error.

Re: [GENERAL] syntax error foreign key

2005-08-16 Thread Matthew Terenzio
On Aug 16, 2005, at 9:37 PM, Matthew Terenzio wrote: db=# ALTER TABLE ONLY table ADD CONSTRAINT "$1" FOREIGN KEY (user) REFERENCES users(user_id); ERROR: syntax error at or near "user" at character 56 I'm either blind or something besides syntax can cause this error. no? changed the fiel