Reference integrity question

From: Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Reference integrity question
Date: 2002-12-27 13:32:54
Message-ID: Pine.LNX.4.33.0212271659220.19571-100000@ns.terminal.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ScottRArndt 2002-12-27 13:57:56 Re: Stuck on SQL Query where a calculated value is used for a join.
Previous Message Rajesh Kumar Mallah. 2002-12-27 11:17:34 Re: COPY command problems