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>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: bug: the schema oid can't be located, please refresh all schemas
Date: 2008-01-31 12:53:27
Message-ID: 937d27e10801310453u7f0ff8aem22a75209034b0507@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Jan 31, 2008 12:43 PM, Thomas H. <me(at)alternize(dot)com> wrote:
> dave,
>
> i wonder if you received my testcase dbdump i've mailed you offlist some
>   days ago (see below)... please let me know if i should resend it (and
> if so, where to so you can get it properly).

Err yes - I replied on January the 10th:

[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

Responses

pgadmin-support by date

Next:From: Raymond O'DonnellDate: 2008-01-31 17:38:11
Subject: Triggers?
Previous:From: Thomas H.Date: 2008-01-31 12:43:58
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