Re: [PATCH] [v8.5] Security checks on largeobjects - Mailing list pgsql-hackers

From KaiGai Kohei
Subject Re: [PATCH] [v8.5] Security checks on largeobjects
Date
Msg-id 4A47FD8D.8090705@ak.jp.nec.com
Whole thread Raw
In response to Re: [PATCH] [v8.5] Security checks on largeobjects  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: [PATCH] [v8.5] Security checks on largeobjects  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Bernd Helmle wrote:
> --On 26. Juni 2009 13:08:37 +0900 KaiGai Kohei <kaigai@ak.jp.nec.com> 
> wrote:
> 
>>  * Is the named large object (including fully qualified one) worth?
>>    It will enables us to specify a largeobject with human readable
>>    identifier string.
> 
> I don't understand the notion of this. Does this mean you can create a 
> LO with an identifier string, generated from (e.g.) your application?

Yes, it intends to assign an identifier string not only numeric
large object identifier. The identifier string can be qualified
with a certain namespace as follows.

E.g)SELECT lo_open('my_picture01', x'40000'::int);SELECT lo_create('pg_temp.my_musid02');

In the later case, the new largeobject will be reclaimed after
the session closed due to the temporary namespace.

Thanks,
-- 
OSS Platform Development Division, NEC
KaiGai Kohei <kaigai@ak.jp.nec.com>


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: pre-proposal: permissions made easier
Next
From: Robert Haas
Date:
Subject: Re: dependencies for generated header files