Re: [HACKERS] Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers

2011-11-11 Thread Alvaro Herrera 

Excerpts from Daniel Farina's message of vie nov 11 16:08:01 -0300 2011:
 On Thu, Nov 10, 2011 at 11:57 PM, Nikhil Sontakke nikkh...@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.

Wasn't 7.3 the release that introduced schemas in the first place?  I
wonder if there's any other kind of container sort of object that
could present a similar problem, in releases prior to that.

If we delay fixing it for 16 more days, it would last nine years.

-- 
Álvaro Herrera alvhe...@commandprompt.com
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers

2011-11-11 Thread Tom Lane 
Alvaro Herrera alvhe...@commandprompt.com writes:
 Excerpts from Daniel Farina's message of vie nov 11 16:08:01 -0300 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.

 Wasn't 7.3 the release that introduced schemas in the first place?

I think there's a very good chance that the older reports with similar
symptoms are completely unrelated, anyhow.

regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers

2011-11-11 Thread Nikhil Sontakke 
  Wasn't 7.3 the release that introduced schemas in the first place?

 I think there's a very good chance that the older reports with similar
 symptoms are completely unrelated, anyhow.


Tom Lane is reluctant and that should tell me something :)

So unless the list feels that this should be fixed and also agrees on the
general approach, I will not touch a single line of code. Obviously someone
else is welcome to have a stab at this too.

Regards,
Nikhils