Re: unusual "relation xxx does not exist" problem

On Wed, Jun 28, 2006 at 09:02:04AM -0700, Bill Eaton wrote:
> I'm trying to migrate a database cluster from one server to another. So I
> did a pg_dumpall, ported everything over, yada yada yada.
>
> I have one particular schema in one particular database that is giving me
> trouble. All names for tables, sequences, functions, etc. are lowercase. I
> repeat: everything is lowercase.
>
> I'm using pgadmin iii to look at everything and I continually get "relation
> not found" errors with my "failurelog" table and other tables. I've tried
> DROP CASCADEing the schema and database and then rebuilding one table at a
> time, but it just is not working.
>
> I've also done another experiment where I create a brand new table that
> never existed. I still get "relation not found" errors on that table. The
> only common thread seems to be the schema.
>
> The name of the schema is
> bar
>
> "bar" is not a reserved word in PostgreSQL, according to the documentation.
> Is there any corrupted information that might be stored in the templates
> (template0 template1) that would account for this problem? Could it be a bug
> in pgadmin?

Possibly. Can you reproduce it in psql? Keep in mind you'll need to
either specify the schema name or ensure that bar is in search_path.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461