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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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).

regards, thomas

-------- Original Message --------
Subject: Re: [pgadmin-support] bug: the schema oid can't be located, please refresh all schemas
From: Thomas H. <me(at)alternize(dot)com>
To: Dave Page <dpage(at)postgresql(dot)org>
Date: 09.01.2008 23:09

hi dave

i hope its fine contacting you off-list for the dump:

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.

i've been able to reproduce the error after loading the dump. the error happens when clicking on the "forum.posts" table node in pgAdmin3.

if i can help with further information, don't hesitate to ask

regards,
thomas





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group