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 ? thank in advance, --- .evgen ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
