At 01:33 20/04/2002 -0400, you wrote: >Unfortunately, the following SQL is generated: > >ALTER TABLE CTLG_SAVED_ITEM > ADD CONSTRAINT USER_ID FOREIGN KEY (USER_ID) > REFERENCES CTLG_USER (USER_ID); > >I need the SQL to reflect TURBINE_USER as the foreign table, not CTLG_USER. >Does anyone have any suggestions as to why this is happening, and how I >might be able to solve the problem?
I noted this before Michael - see http://www.mail-archive.com/[email protected]/msg05399.html MySQL doesn't seem to mind but postgres will choke. I simply renamed the foreign-key reference *after* the code had been generated and manually rebuilt the db - have experienced no problems. c ................................................................ colm mccartan panasonic owl uk [EMAIL PROTECTED] (44) 131 561 1035 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
