Re: Largeobject Access Controls (r2460)

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, KaiGai Kohei <kaigai(at)kaigai(dot)gr(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 18:27:44
Message-ID: 20100204182744.GD5698@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2010-02-04 18:29:43 Re: testing cvs HEAD - HS/SR - cannot stat
Previous Message Ivan Sergio Borgonovo 2010-02-04 18:24:02 building tsquery directly in memory (avoid makepol)