Re: [SQL] Reference integrity question

2003-01-04 Thread Stephan Szabo
On Sat, 4 Jan 2003, Evgen Potemkin wrote: > > > 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.

Re: [SQL] Reference integrity question

2003-01-02 Thread Stephan Szabo
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_ol

[SQL] Reference integrity question

2003-01-01 Thread Evgen Potemkin
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