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

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

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