Re: pg_dump --> restore loses constraints/triggers? - Mailing list pgsql-general

From Christopher Murtagh
Subject Re: pg_dump --> restore loses constraints/triggers?
Date
Msg-id Pine.LNX.4.44.0302180100510.3063-100000@blues.wcg.mcgill.ca
Whole thread Raw
In response to Re: pg_dump --> restore loses constraints/triggers?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 17 Feb 2003, Tom Lane wrote:
>Which pg_dump did you use?  I think 7.3's pg_dump would translate the 7.1
>trigger-based representation correctly, but 7.1's wouldn't know any
>better than to emit CREATE CONSTRAINT TRIGGER commands.
>
>(But as far as I know, the constraint triggers ought to *work*, they
>just won't look pretty.  Please define "broken".)

 Thanks for the speedy reply Tom. I used 7.1 pg_dump, and unfortunately,
the server isn't running anymore. When I said 'broken' I really meant that
they weren't there - no constraints, and neither were any corresponding
CREATE CONSTRAINT TRIGGERs.

 We use Postgres (and really *love* it) as part of our home-grown central
web system (www.mcgill.ca), and it is constantly evolving. The switchover
happened 10 days ago, and I suspect it would be more work to try to sync
the changes than to re-create foreign key constraints.

 Thanks again.

Cheers,

Chris

--

Christopher Murtagh
Webmaster / Sysadmin
Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax:  (514) 398-2017



pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: [HACKERS] Group by, count, order by and limit
Next
From: Emmanuel Charpentier
Date:
Subject: Aggregate definition : small oversight ?