From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Evgen Potemkin <evgent@ns.terminal.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: Reference integrity question
Date: Sat, 4 Jan 2003 07:16:25 -0800 (PST)
Message-ID: <20030104071505.Y20289-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <Pine.LNX.4.33.0301041750560.19906-100000@ns.terminal.ru>
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.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;
> >
> v 7.3, but i'm upgraded from 7.2
> \d news
> shows that there is no constraints, but constraint triggers a la
> RI_ConstraintTrigger_262762.
> when i'm dumps schema, first of trigger func parameters is '<unnamed>', so i
> guess it's a contraint name.
In that case you'll need to drop the triggers manually (there are three
triggers, one on the fk table and two on the pw table) and add the
constraint using ALTER TABLE. For info on the triggers, there's a couple
of documents on techdocs.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, evgent@ns.terminal.ru
Subject: Re: Reference integrity question
In-Reply-To: <20030104071505.Y20289-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox