Hi, My sql appears to be missing my "i" schema. I believe it should
be "REFERENCES i.tblsites". When I make it with "i." it works fine.
Thanks for any ideas.
John
-- Foreign Key: i.fk_tblsatellitemanager_tblsites_fk
-- ALTER TABLE i.tblsitegroups DROP CONSTRAINT
fk_tblsatellitemanager_tblsites_fk
ALTER TABLE i.tblsitegroups
ADD CONSTRAINT fk_tblsitegroups_tblsites_fk FOREIGN KEY (maskedsiteid)
REFERENCES tblsites (maskedsiteid) ON UPDATE CASCADE ON DELETE CASCADE;
--
Best regards,
John Bercik E-Mail: [EMAIL PROTECTED]
Systems Programmer Office: 843/792-1715
Medical University of South Carolina Fax: 843/792-0816
Room 826F Clinical Science Building
76 Jonathan Lucas Street
Charleston, SC, USA 29425
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
