Both fixed now in CVS - thanks for the report. Regards, Dave.
> -----Original Message----- > From: John Bercik [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 16:53 > To: pgadmin support > Subject: Re: [pgadmin-support] schema support > > > and also a ; is needed after > > -- ALTER TABLE i.tblsitegroups DROP CONSTRAINT > > fk_tblsatellitemanager_tblsites_fk > > > On Wed, 2003-07-02 at 11:47, John Bercik wrote: > > 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 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
