From: | KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Largeobject Access Controls (r2460) |
Date: | 2010-02-04 21:17:07 |
Message-ID: | 4B6B3953.7000601@kaigai.gr.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
(2010/02/05 3:27), Alvaro Herrera wrote:
> Robert Haas escribió:
>> 2010/2/4 KaiGai Kohei<kaigai(at)ak(dot)jp(dot)nec(dot)com>:
>>> (2010/02/04 0:20), Robert Haas wrote:
>>>> 2010/2/1 KaiGai Kohei<kaigai(at)ak(dot)jp(dot)nec(dot)com>:
>>>>> I again wonder whether we are on the right direction.
>>>>
>>>> I believe the proposed approach is to dump blob metadata if and only
>>>> if you are also dumping blob contents, and to do all of this for data
>>>> dumps but not schema dumps. That seems about right to me.
>>>
>>> In other words:
>>>
>>> <default> -> blob contents and metadata (owner, acl, comments) shall
>>> be dumped
>>> --data-only -> only blob contents shall be dumped
>>> --schema-only -> neither blob contents and metadata are dumped.
>>>
>>> Can I understand correctly?
>>
>> No, that's not what I said. Please reread. I don't think you should
>> ever dump blob contents without the metadata, or the other way around.
>
> So:
> default: both contents and metadata
> --data-only: same
> --schema-only: neither
>
> Seems reasonable.
OK... I'll try to update the patch, anyway.
However, it means only large object performs an exceptional object class
that dumps its owner, acl and comment even if --data-only is given.
Is it really what you suggested, isn't it?
Thanks,
--
KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-02-04 23:53:46 | pg_class has no toast table? |
Previous Message | Teodor Sigaev | 2010-02-04 19:13:02 | Re: building tsquery directly in memory (avoid makepol) |