(2018/06/22 18:49), Amit Langote wrote:
On 2018/06/22 18:15, Etsuro Fujita wrote:
I'd vote for #2. One idea for that is to introduce CREATE FOREIGN INDEX
to have information on remote indexes on the local side, which I proposed
before. I have been putting it on hold since then, though.
Sorry to hijack this thread, but I'd like to say that CREATE FOREIGN INDEX
would be nice, as that would also let us lift certain restrictions on
partitioned table indexes [1].
Agreed. I think that would be useful to support INSERT ... ON CONFLICT
fully not only on single foreign tables but partitioned tables
containing foreign partitions.
Best regards,
Etsuro Fujita