David Wall 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 --- y
On 12/16/2012 6:21 PM, Tom Lane wrote:
David Wall 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_priv
On 12/16/2012 6:21 PM, Tom Lane wrote:
David Wall 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_priv
David Wall 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.c
On 12/16/2012 11:22 AM, Tom Lane wrote:
David Wall writes:
In past PG upgrades, we've done a pg_dump on the current version, then a
pg_restore on the new version. But during the 8.4 to 9.2 upgrade (on
Linux x64), we ran into issues with the permissions associated with the
large objects after
David Wall writes:
> In past PG upgrades, we've done a pg_dump on the current version, then a
> pg_restore on the new version. But during the 8.4 to 9.2 upgrade (on
> Linux x64), we ran into issues with the permissions associated with the
> large objects after the restore.
Large objects didn'
On 12/16/2012 11:09 AM, David Wall wrote:
In past PG upgrades, we've done a pg_dump on the current version, then a
pg_restore on the new version. But during the 8.4 to 9.2 upgrade (on
Linux x64), we ran into issues with the permissions associated with the
large objects after the restore.
Is thi
