| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| lobj-acl-err.txt | text/plain | 609 bytes |
| lobjoidfix.patch | application/octet-stream | 5.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gardner | 2010-06-10 00:55:36 | 'create or replace function' no longer allows parameters |
| Previous Message | Tom Lane | 2010-06-10 00:01:58 | Re: Keepalive for max_standby_delay |