Re: Reconstructing FKs in pg_dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reconstructing FKs in pg_dump
Date
Msg-id 11480.1033075252@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reconstructing FKs in pg_dump  (Rod Taylor <rbt@rbt.ca>)
Responses Re: Reconstructing FKs in pg_dump  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> However, if they're coming from 7.0 or earlier would it be appropriate
> to have them bounce through 7.2 / 7.1 first?

Won't help.  7.2 will dump 'em out without a FROM clause, just like they
were loaded.

> Is this the only problem that 7.0 people are going to experience (server
> side, SQL changes are abundant)?

You're missing the point.  Welche was upgrading *from 7.2*.  But his
trigger definitions had a dump/reload history going back to 7.0.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Reconstructing FKs in pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Reconstructing FKs in pg_dump