Search Postgresql Archives

Re: PG 8.4 to 9.2 upgrade issues with ownership of large objects

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/16/2012 6:21 PM, Tom Lane wrote:
David Wall <d.wall@xxxxxxxxxxxx> writes:
On 12/16/2012 11:22 AM, Tom Lane wrote:
Large objects didn't have privileges, nor owners, in 8.4. If you don't
feel like fixing your apps right now, you can return to the previous
behavior by setting the obscurely-named lo_compat_privileges setting in
postgresql.conf.

I'll read up more on permissions as they relate large objects.


Okay, I cannot find any information on how to view the permissions for a large object. I know that psql's \dp can be used to see the permissions on a table, but how do I see the permissions assigned to a large object?

The docs show how to use GRANT/REVOKE.... ON LARGE OBJECT loid, and a script that shows ALTER LARGE OBJECT loid OWNER TO..., but I don't see anything about retrieving the loid's permissions.

Thanks, David


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux