Re: alter table workaround - Mailing list pgsql-general

From Aasmund Midttun Godal
Subject Re: alter table workaround
Date
Msg-id 20011031171031.21659.qmail@ns.krot.org
Whole thread Raw
In response to Re: alter table workaround  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: alter table workaround  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Well, the foreign keys are dumped out as separate statements, so I think it will work. It's definitely worth a try...

Regards,

Aasmund.

On Wed, 31 Oct 2001 08:27:10 -0800 (PST), Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
>
> On Wed, 31 Oct 2001 wsheldah@lexmark.com wrote:
>
>
> It depends.  If this table is referenced by other tables (for example)
> I don't think that will re-add the constraint to the other table.  There
> may be issues like that that you'd run into.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46

pgsql-general by date:

Previous
From: Randall Perry
Date:
Subject: Re: serial sequence problem with existing keys
Next
From: Stephan Szabo
Date:
Subject: Re: alter table workaround