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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers
Дата
Msg-id 1321039140-sup-4806@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers  (Daniel Farina <daniel@heroku.com>)
Ответы Re: Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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 <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.

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 <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: why do we need two snapshots per query?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: pg_dump: schema with OID XXXXX does not exist - was Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers