On Fri, 27 Dec 2002, Evgen Potemkin wrote: > Good time of day! > > I have two tables > news(newsid int4, newscltid int4 references clt(cltid) match full,newstext text) > and > clt(cltid int4, somedata text). > after clt is renamed , for ex. to clt_old, newscltid start to reference to >clt_old.cltid. > i'm create new table clt(cltid int4, anotherdata text); > > is there any way to make newscltid reference to newly created clt, beside > recreation of news ?
If you mean that all newscltids should reference the new table (presumably already loaded)... Since you haven't given a version, let's guess 7.3, in which case the constraint should probably be named "$1" and you can do an ALTER TABLE news drop constraint "$1"; ALTER TABLE news add foreign key (newscltid) references clt(cltid) match full; but it's tougher in older versions. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
