Skip site navigation (1) Skip section navigation (2)

Re: bug: the schema oid can't be located, please refresh all schemas

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Thomas H(dot)" <me(at)alternize(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: bug: the schema oid can't be located, please refresh all schemas
Date: 2008-01-10 10:21:54
Message-ID: 937d27e10801100221r45a7071cgc92b70b42504cf92@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
[Going back on-list]

On 09/01/2008, Thomas H. <me(at)alternize(dot)com> wrote:
> hi dave
>
> i hope its fine contacting you off-list for the dump:

No problem at all.

> > I cannot recreate this on 8.3rc1 using a dummy table and the
> > trigger/procedure you posted. Can you provide me with a more complete
> > example in a pg_dump format please?
>
> attached you find a pg_dump in text-format of a simple test database.
> its basically the original db with the additional schemas, uninvolved
> tables and all data removed. i've changed the object owner to
> "postgres", so an empty utf8 db is all that's needed for loading the dump.

Great, thanks - I spotted some code during unrelated work that I
guessed might be the cause and your test case confirmed that it was.
I've committed a fix to SVN for 1.8.2.

Thanks, Dave

In response to

pgadmin-support by date

Next:From: Lucas DetersDate: 2008-01-10 13:44:38
Subject: Bug with very low negative sequence values
Previous:From: Thomas H.Date: 2008-01-09 14:17:06
Subject: Re: bug: the schema oid can't be located, please refresh all schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group