Re: Largeobject Access Controls (r2460)

Поиск
Список
Период
Сортировка
Искать
От
Takahiro Itagaki
Тема
Re: Largeobject Access Controls (r2460)
Дата
Msg-id
20100202093341.9A60.52131E4D@oss.ntt.co.jp
Ответ на
Список
Дерево обсуждения
[PATCH] Largeobject Access Controls (r2432) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [PATCH] Largeobject Access Controls (r2432) Jaime Casanova <jcasanov@systemguards.com.ec>
Re: [PATCH] Largeobject Access Controls (r2432) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [PATCH] Largeobject Access Controls (r2432) Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: [PATCH] Largeobject Access Controls (r2432) KaiGai Kohei <kaigai@ak.jp.nec.com>
[PATCH] Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [PATCH] Largeobject Access Controls (r2460) Greg Smith <greg@2ndquadrant.com>
Re: [PATCH] Largeobject Access Controls (r2460) Jaime Casanova <jcasanov@systemguards.com.ec>
Re: [PATCH] Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Alvaro Herrera <alvherre@commandprompt.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Alvaro Herrera <alvherre@commandprompt.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) Robert Haas <robertmhaas@gmail.com>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Tom Lane <tgl@sss.pgh.pa.us>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Bruce Momjian <bruce@momjian.us>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls (r2460) Bruce Momjian <bruce@momjian.us>
Largeobject Access Controls and pg_migrator Bruce Momjian <bruce@momjian.us>
Re: Largeobject Access Controls and pg_migrator KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls and pg_migrator Bruce Momjian <bruce@momjian.us>
Re: Largeobject Access Controls and pg_migrator Bruce Momjian <bruce@momjian.us>
Re: Largeobject Access Controls and pg_migrator KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls and pg_migrator Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls and pg_migrator Bruce Momjian <bruce@momjian.us>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Largeobject Access Controls (r2460) Jaime Casanova <jcasanov@systemguards.com.ec>
Re: Largeobject Access Controls (r2460) Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: [PATCH] Largeobject Access Controls (r2460) KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [PATCH] Largeobject Access Controls (r2460) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: [PATCH] Largeobject Access Controls (r2432) Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] Largeobject Access Controls (r2432) Greg Smith <greg@2ndquadrant.com>
Re: [PATCH] Largeobject Access Controls (r2432) Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] Largeobject Access Controls (r2432) Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCH] Largeobject Access Controls (r2432) Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] Largeobject Access Controls (r2432) Tom Lane <tgl@sss.pgh.pa.us>
Re: [PATCH] Largeobject Access Controls (r2432) Robert Haas <robertmhaas@gmail.com>
Re: [PATCH] Largeobject Access Controls (r2432) Greg Smith <greg@2ndquadrant.com>

KaiGai Kohei  wrote:

> > Can we remove such path and raise an error instead?
> > Also, even if we support the older servers in the routine,
> > the new bytea format will be another problem anyway.
> 
> OK, I'll fix it.

I think we might need to discuss about explicit version checks in pg_restore.
It is not related with large objects, but with pg_restore's capability.
We've not supported to restore a dump to older servers, but we don't have any
version checks, right? Should we do the checks at the beginning of restoring?
If we do so, LO patch could be more simplified.


> The --schema-only with large objects might be unnatural, but the
> --data-only with properties of large objects are also unnatural.
> Which behavior is more unnatural?

I think large object metadata is a kind of row-based access controls.
How do we dump and restore ACLs per rows when we support them for
normal tables? We should treat LO metadata as same as row-based ACLs.
In my opinion, I'd like to treat them as part of data (not of schema).

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center



В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Takahiro Itagaki
Дата:
FAQ