Thread: Error in pgAdminIII

Error in pgAdminIII

From
"Arnold, Sandra"
Date:
I am getting the following error in pgAdminIII. I receive the error when I double click on a table under a schema that I own. 
 
First I can't find any documentation on what this error means.  Second, my PostgreSQL account is a superuser account.
 
An error has occurred:
  ERROR:  could not open relationship
                16389/16385/16464:
                Permission denied
 
Any help would be greatly appreciated.
 
Thanks,

Sandra Arnold
Sr. DBA
DOE/OSTI

Re: Error in pgAdminIII

From
Richard Huxton
Date:
Arnold, Sandra wrote:
> I am getting the following error in pgAdminIII. I receive the error when
> I double click on a table under a schema that I own.
>
> First I can't find any documentation on what this error means.

Always handy to have a copy of the source and a text search tool, even
if you can't read "C".

 > Second,
> my PostgreSQL account is a superuser account.

Aha! Windows

> An error has occurred:
>   ERROR:  could not open relationship
Assuming that says "relation" not relationship then it's a filesystem
error in backend/storage/smgr/md.c about line 520

You either have:
1. Messed up permissions on your data directory
2. An interfering antivirus


--
   Richard Huxton
   Archonet Ltd