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]

 



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 am using the latest JDBC driver and have not noted any other issues 
> with large objects accessed, created or deleted using the blob 
> interfaces.  What does fixing an app mean or entail?  We've always 
> accessed large objects as a simple blob stored and referenced in a table 
> as an OID with both having the same lifetime.

It would only be an issue if you created large objects under one role
and then tried to access them under another, since the default
permissions would forbid that.  I assumed since you were complaining
that you'd run into something of the sort ...

			regards, tom lane


-- 
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