Re: Foriegn key constraint

From: Jie Liang <jliang(at)jliang(dot)ipinc(dot)com>
To: "Sivagami (dot)" <sivagami(at)worlddata(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Foriegn key constraint
Date: 2000-12-12 18:28:47
Message-ID: Pine.BSF.4.21.0012121022350.25634-100000@jliang.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,there,

You may try use pg_dump to recover :
pg_dump -t tablename -f outfile dbname
then use vi to erase the foreign key from outfile.
drop your original tables, reload your tables
without foreign key.

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

On Tue, 5 Dec 2000, Sivagami . wrote:

[NON-Text Body part not included]

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lamar Owen 2000-12-12 18:47:19 Re: v7.1 RPMs
Previous Message Adam Lang 2000-12-12 18:24:16 Re: v7.1 RPMs