Re: Foriegn key constraint - Mailing list pgsql-admin

From Jie Liang
Subject Re: Foriegn key constraint
Date
Msg-id Pine.BSF.4.21.0012121022350.25634-100000@jliang.ipinc.com
Whole thread Raw
In response to Foriegn key constraint  ("Sivagami ." <sivagami@worlddata.com>)
List 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@ipinc.com
www.ipinc.com

On Tue, 5 Dec 2000, Sivagami . wrote:


  [NON-Text Body part not included]


pgsql-admin by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Which Linux Distribution
Next
From: Lamar Owen
Date:
Subject: Re: Re: [GENERAL] postmaster does not start up