On Nov 29, 2007, at 12:05 PM, Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
I just noticed this. In the section of the page, near the end, that
describes the access privileges display generated by psql's \z (which
come from pg_class.relacl) there is the following:
/yyyy -- user who granted this privilege
That's not the case. What get's listed there is the current owner of
the table (at least in 8.2).
Your test case does not show that. I think you missed this paragraph:
: If a superuser chooses to issue a GRANT or REVOKE command, the
command
: is performed as though it were issued by the owner of the affected
: object. In particular, privileges granted via such a command will
appear
: to have been granted by the object owner. (For role membership, the
: membership appears to have been granted by the containing role
itself.)
regards, tom lane
Ah, thanks, I did miss that one.
Erik Jones
Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(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
