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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
