Re: problems with postgres foreign keys
i)CREATE TABLE faq(
TopicId INT NOT NULL,
QuestionId INT NOT NULL
)
;
ii)answerdetails tables should be there
iii)forign key takes place here
ALTER TABLE FAQ ADD CONSTRAINT RefAnswerDetails17
FOREIGN KEY (answerid)
REFERENCES answerdetails(answerid)
;
just try it u wil get answer
Subject
Views
Written By
Posted
6478
August 25, 2005 01:22PM
3992
August 25, 2005 03:34PM
3420
August 26, 2005 09:29PM
Re: problems with postgres foreign keys
3667
March 21, 2006 10:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.