"Qayed" <qayedjohar@gmail.com> writes:
> While trying to connect to postgresql database i m gettting this error,
> FATAL:could not open relation "pg_trigger_tgrelid_tgname_index":Permission
> denied.

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