Skip site navigation (1) Skip section navigation (2)

Re: parser handling of large object OIDs

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: parser handling of large object OIDs
Date: 2010-06-10 00:45:48
Message-ID: AANLkTinKniGkHnHnD0O8vNwbGHxDByfH09wEYZk6C1Mp@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Jun 9, 2010 at 5:02 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> I believe that the comment code is probably right, because I think
> IConst can only handle values < 2^31, whereas OIDs can be as large as
> 2^32-1.

I investigated this a little more and the above analysis turns out to
be correct.  ALTER LARGE OBJECT OWNER and GRANT ... ON LARGE OBJECT
don't work for large objects outside the range of a signed integer.
Session demonstrating the problem and proposed patch attached.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

Attachment: lobjoidfix.patch
Description: application/octet-stream (5.7 KB)
Attachment: lobj-acl-err.txt
Description: text/plain (609 bytes)

In response to

Responses

pgsql-hackers by date

Next:From: David GardnerDate: 2010-06-10 00:55:36
Subject: 'create or replace function' no longer allows parameters
Previous:From: Tom LaneDate: 2010-06-10 00:01:58
Subject: Re: Keepalive for max_standby_delay

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group