Postgres Pro
Downloads
Home   >   mailing lists

Re: PG 8.4 to 9.2 upgrade issues with ownership of large objects - Mailing list pgsql-general

From Tom Lane
Subject Re: PG 8.4 to 9.2 upgrade issues with ownership of large objects
Date
Msg-id 29811.1355772641@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG 8.4 to 9.2 upgrade issues with ownership of large objects  (David Wall <d.wall@computer.org>)
List pgsql-general
Tree view 
David Wall <d.wall@computer.org> writes:
> 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?

AFAICS psql doesn't have any support for this --- you'd need to look
directly at pg_largeobject_metadata.

            regards, tom lane

pgsql-general by date:

Previous
From: David Wall
Date:
Subject: Re: PG 8.4 to 9.2 upgrade issues with ownership of large objects
Next
From: James Cowell
Date:
Subject: Re: Corrupt indexes on slave when using pg_bulkload on master