From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: FK disappeared in 8.3.3
Date: Tue, 23 Nov 2010 10:22:29 -0500
Message-ID: <8602.1290525749@sss.pgh.pa.us> (raw)
In-Reply-To: <201011231014.57430.achill@matrix.gatewaynet.com>
References: <201011221213.32035.achill@matrix.gatewaynet.com>
<4CEA30A90200002500037CE1@gw.wicourts.gov>
<27456.1290442272@sss.pgh.pa.us>
<201011231014.57430.achill@matrix.gatewaynet.com>
Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> At this time our problematic vessel was running 7.4.2. This vessel upgraded to 8.3.3
> some time in January 2009.
7.4!?
I can't shake the suspicion that some of your issues arose from trying
to load a later-version pg_dump output into an older-version server.
The discrepancies you're seeing are closely related to places where
we've changed pg_dump's output over the years, and not always in
backwards-compatible ways. The older server would throw syntax errors
on the newer commands, and if you didn't notice or follow up on that
during the reload, the outcome would be that the objects those commands
tried to create would just not be there. Which is what you've got.
I don't have enough information to show the exact chain of events, but I
think that something like this is a lot more probable than a random
hardware failure that just happened to produce these particular results.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, achill@matrix.gatewaynet.com
Subject: Re: FK disappeared in 8.3.3
In-Reply-To: <8602.1290525749@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox