Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers - Mailing list pgsql-hackers

From Daniel Farina
Subject Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers
Date
Msg-id CAAZKuFb2d1EqgLY7BV3d1hYW613q2FUOrHuqXVR12a8sT=6waQ@mail.gmail.com
Whole thread Raw
In response to pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers  (Nikhil Sontakke <nikkhils@gmail.com>)
Responses Re: Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers
List pgsql-hackers
On Thu, Nov 10, 2011 at 11:57 PM, Nikhil Sontakke <nikkhils@gmail.com> wrote:
> Hi,
>
>>
>> But if it's deemed to be a
>> problem, I want to see a solution that's actually watertight.)
>>
>
> After Daniel's hunch about pg_dump barfing due to such leftover entries
> proving out to be true, we have one credible explanation (there might be
> other reasons too) for this long standing issue. I see some reports from as
> early as 2004 and some as latest as Feb, 2011!

The 2004 report was in version 7.3, released in 2002.  So it's Very
Nearly a ten year old bug, and may very well go back further back in
time.

-- 
fdr


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Multiple Extensions
Next
From: Dimitri Fontaine
Date:
Subject: Re: why do we need two snapshots per query?