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

ERROR: RelationCatalogInformation: Relation 20705 not found

From: Brett McCormickS <brett(at)abraxas(dot)scene(dot)com>
To: pgsql-hackers(at)hub(dot)org
Subject: ERROR: RelationCatalogInformation: Relation 20705 not found
Date: 1998-05-14 00:19:24
Message-ID: 199805140019.RAA11855@abraxas.scene.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I dropped and recreated a table and then tried to access it from a previously
opened database connection (mod_perl).  I did do a pg_dump -z -s -t for
the table info, and just changed a not null attribute.  (anyway to change
without recreating table?)

I could not reproduce it in another db, but -- I was using two different
users in this case, and the user of the previously opened connection
was affected by the grant.

It would appear that we have some catalog cache updating problems..
Closing the connection and re-opening always seems to fix it.

pgsql-hackers by date

Next:From: Brett McCormickSDate: 1998-05-14 00:21:56
Subject: relation not found -- I was selecting from a view
Previous:From: Michal MosiewiczDate: 1998-05-13 20:26:55
Subject: Re: [HACKERS] mmap and MAP_ANON

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