Wow, nevermind. What I must not understand is my own code. Yikes, what
a bonehead.
--- Begin Message ---
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: I must not understand the permissions system
- From: David Rysdam <drysdam@xxxxxxxxxx>
- Date: Thu, 10 Nov 2005 09:31:07 -0500
- User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.11) Gecko/20050729
From both User A and User B, this query returns rows:
select * from pg_trigger where tgname = '<name>'
but User A gets 2 rows (because I have the same trigger name on two
different tables) while User B only sees one of them. Is it permissions
on pg_trigger or on the original table (or some other thing) that is
preventing B from seeing that row?
--- End Message ---
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
