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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
