Request a Demo
Home   >   mailing lists

Re: Indexes on partitioned tables and foreign partitions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Indexes on partitioned tables and foreign partitions
Date
Msg-id CA+Tgmob+oJ=nwE0M0AgMf8C3kDnO+WOby4FZ6mHor0Ln9zy2ug@mail.gmail.com
Whole thread Raw
In response to Re: Indexes on partitioned tables and foreign partitions  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Wed, May 9, 2018 at 11:12 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> If we can assume an index exists on a foreign table, why can we not
> just assume a unique index exists?? Why the difference?

We can't assume either of those things, and I didn't say that we should.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Indexes on partitioned tables and foreign partitions
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Cutting initdb's runtime (Perl question embedded)