Re: inherit support for foreign tables
От
Ashutosh Bapat
Тема
Re: inherit support for foreign tables
Дата
Msg-id
CAFjFpRcFdb1Xr5FkBjxWudnV0DuLr6i3Ue-wcNhU8d0h9=E2ag@mail.gmail.com
Ответ на
Re: inherit support for foreign tables (Etsuro Fujita)
Список
Дерево обсуждения
inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Inheritance and indexes knizhnik <knizhnik@garret.ru>
Re: Inheritance and indexes Marti Raudsepp <marti@juffo.org>
Re: inherit support for foreign tables KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables David Fetter <david@fetter.org>
Re: inherit support for foreign tables Atri Sharma <atri.jiit@gmail.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kouhei Kaigai <kaigai@ak.jp.nec.com>
Re: inherit support for foreign tables Atri Sharma <atri.jiit@gmail.com>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Stephen Frost <sfrost@snowman.net>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Stephen Frost <sfrost@snowman.net>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Noah Misch <noah@leadboat.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Noah Misch <noah@leadboat.com>
Re: inherit support for foreign tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Heikki Linnakangas <hlinnakangas@vmware.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Heikki Linnakangas <hlinnakangas@vmware.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Heikki Linnakangas <hlinnakangas@vmware.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables David Fetter <david@fetter.org>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Noah Misch <noah@leadboat.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Stephen Frost <sfrost@snowman.net>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: inherit support for foreign tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables David Fetter <david@fetter.org>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Andres Freund <andres@anarazel.de>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Robert Haas <robertmhaas@gmail.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Michael Paquier <michael.paquier@gmail.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Michael Paquier <michael.paquier@gmail.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables <furuyao@pm.nttdata.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Compute attr_needed for child relations (was Re: inherit
support for foreign tables) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Compute attr_needed for child relations (was Re:
inherit support for foreign tables) Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Compute attr_needed for child relations (was Re: inherit
support for foreign tables) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Compute attr_needed for child relations (was Re: inherit support for foreign tables) Tom Lane <tgl@sss.pgh.pa.us>
Re: Compute attr_needed for child relations (was Re: inherit
support for foreign tables) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Compute attr_needed for child relations (was Re: inherit support for foreign tables) Tom Lane <tgl@sss.pgh.pa.us>
Re: Compute attr_needed for child relations (was Re: inherit
support for foreign tables) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Compute attr_needed for child relations (was Re:
inherit support for foreign tables) Shigeru Hanada <shigeru.hanada@gmail.com>
Re: Compute attr_needed for child relations (was Re:
inherit support for foreign tables) Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Compute attr_needed for child relations (was Re: inherit
support for foreign tables) Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: Compute attr_needed for child relations (was Re:
inherit support for foreign tables) Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
[BUG?] tuples from file_fdw has strange xids. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [BUG?] tuples from file_fdw has strange xids. Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUG?] tuples from file_fdw has strange xids. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables "Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Tom Lane <tgl@sss.pgh.pa.us>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: inherit support for foreign tables Shigeru Hanada <shigeru.hanada@gmail.com>
Re: inherit support for foreign tables Jim Nasby <jim@nasby.net>
I checked that it's reporting the right tableoid now.
BTW, why aren't you using the tlist passed to this function? I guess create_scan_plan() passes tlist after processing it, so that should be used rather than rel->reltargetlist.On Mon, Jun 30, 2014 at 12:22 PM, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp> wrote:
(2014/06/24 16:30), Etsuro Fujita wrote:(2014/06/23 18:35), Ashutosh Bapat wrote:Done. I think this is because create_foreignscan_plan() makes reference to attr_needed, which isn't computed for inheritance children. To aboid this, I've modified create_foreignscan_plan() to see reltargetlist and baserestrictinfo, instead of attr_needed. Please find attached an updated version of the patch.Selecting tableoid on parent causes an error, "ERROR: cannot extract
system attribute from virtual tuple". The foreign table has an OID which
can be reported as tableoid for the rows coming from that foreign table.
Do we want to do that?
No. I think it's a bug. I'll fix it.
Sorry for the delay.
Best regards,
Etsuro Fujita
--
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company
В списке pgsql-hackers по дате отправления