Re: Reconstructing FKs in pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reconstructing FKs in pg_dump
Date: 2002-09-26 21:20:52
Message-ID: 11480.1033075252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <rbt(at)rbt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-26 21:22:01 Re: Reconstructing FKs in pg_dump
Previous Message Neil Conway 2002-09-26 21:17:30 Re: [HACKERS] Performance while loading data and indexing