Skip site navigation (1) Skip section navigation (2)

postgres_fdw IMPORT SCHEMA and partitioned tables

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: postgres_fdw IMPORT SCHEMA and partitioned tables
Date: 2017-03-09 14:15:31
Message-ID: 20170309141531.GD9812@tamriel.snowman.net (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
Greetings,

While reviewing Amit Langote's patch to handle partitioned tables
properly in various contrib modules (mostly by throwing an error since
things like pageinspect aren't going to work on the empty 'parent'
table), I went looking through contrib for other modules that do
something with relkind and noticed that postgres_fdw's IMPORT SCHEMA
would pull in the child tables (relkind = 'r') but would ignore the
parent table (relkind = 'P', or soon to be 'p', I guess).

I tend to view this as an issue which should be added to the open items
list and resolved before PG10 (though perhaps it could be done after
feature freeze), but I could see an argument that it should be just a
documented limitation of postgres_fdw and that adding such support would
be a new feature.

In any case, this seems like an issue that should be addressed one way
or the other, so I'll add it to the open items list.  I'm not planning
to work on fixing it myself, but if someone proposes a patch which looks
reasonable, I'll try to find time for it.

Thanks!

Stephen

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2017-03-09 14:25:29
Subject: Re: Partitioning vs ON CONFLICT
Previous:From: Alexander KorotkovDate: 2017-03-09 14:04:35
Subject: Re: [PATCH]: fix bug in SP-GiST box_ops

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group