syntax error foreign key

From: Matthew Terenzio <matt(at)jobsforge(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: syntax error foreign key
Date: 2005-08-17 01:37:03
Message-ID: 245092ca0d2ae3ad8315ec8bcd65155c@jobsforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2005-08-17 01:43:08 Re: table clustering brings joy
Previous Message Greg Stark 2005-08-17 01:33:26 Re: table clustering brings joy