Re: [HACKERS] Allowing extended stats on foreign and partitioned tables - Mailing list pgsql-hackers

From David Rowley
Subject Re: [HACKERS] Allowing extended stats on foreign and partitioned tables
Date
Msg-id CAKJS1f_z=ThLU4iE7SHiS02-oMs4WFFFCLQ0N3hN=QvFrgzG=Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Allowing extended stats on foreign and partitioned tables  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On 18 April 2017 at 09:01, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> David Rowley wrote:
>> While reviewing extended stats I noticed that it was possible to
>> create extended stats on many object types, including sequences. I
>> mentioned that this should be disallowed. Statistics were then changed
>> to be only allowed on plain tables and materialized views.
>>
>> This should be relaxed again to allow anything ANALYZE is allowed on.
>>
>> The attached does this.
>
> The error message was inconsistent in the case of indexes, because of
> using heap_open instead of relation_open.  That seemed gratuitous, so I
> flipped it, added test for the whole thing and pushed.

Thanks for changing that and pushing this.

-- David Rowley                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] pg_statistic_ext.staenabled might not be the bestcolumn name
Next
From: David Rowley
Date:
Subject: Re: [HACKERS] extended stats not friendly towards ANALYZE with subsetof columns