| From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | Matthew Terenzio <matt(at)jobsforge(dot)com> |
| Cc: | PgSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: syntax error foreign key |
| Date: | 2005-08-17 02:38:44 |
| Message-ID: | m21x4t5lu3.fsf@Douglas-McNaughts-Powerbook.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Matthew Terenzio <matt(at)jobsforge(dot)com> 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 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?
USER is an SQL keyword; you have to put it in double quotes to use it
as an identifier.
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-08-17 02:44:14 | Re: syntax error foreign key |
| Previous Message | Michael Fuhr | 2005-08-17 02:31:15 | Re: syntax error foreign key |