Re: syntax error foreign key

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. no?
>>
>>
>
> changed the field name to userid and it;s fine. Can't user the word
> user for field that references?

probably if you quote it.

Sincerely,

Joshua D. Drake

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster