lobj-acl-err.txt

text/plain

Filename: lobj-acl-err.txt

Type: text/plain

Part: 0

Message: Re: parser handling of large object OIDs

rhaas=# select lo_create('4000000000');
 lo_create  
------------
 4000000000
(1 row)

rhaas=# comment on large object 4000000000 is 'big!';
COMMENT
rhaas=# create user bob;
CREATE ROLE
rhaas=# grant all privileges on large object 4000000000 to bob;
ERROR:  syntax error at or near "4000000000"
LINE 1: grant all privileges on large object 4000000000 to bob;
                                             ^
rhaas=# select lo_create('80000');
 lo_create 
-----------
     80000
(1 row)

rhaas=# grant all privileges on large object 80000 to bob;
GRANT
rhaas=# comment on large object 80000 is 'smaller';
COMMENT