The following bug has been logged online:

Bug reference: 1835
Logged by: Qayed
Email address: qayedjohar (AT) gmail (DOT) com
PostgreSQL version: 7.4
Operating system: Win XP
Description: pg_trigger_tgrelid_tgname_index
Details:

While trying to connect to postgresql database i m gettting this error,
FATAL:could not open relation "pg_trigger_tgrelid_tgname_index":Permission
denied.
How to solve this issue.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"Qayed" <qayedjohar (AT) gmail (DOT) com> writes:
Apparently the database server is unable to open its own files due to
filesystem permission checks. Perhaps you started the server process
under the wrong user name?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match