tablesample with partitioned tables

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: tablesample with partitioned tables
Date: 2017-02-22 07:51:46
Message-ID: 59af6590-8ace-04c4-c36c-ea35d435c60e@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Attached patch fixes an oversight that tablesample cannot be used with
partitioned tables:

create table p (a int) partition by list (a);
select * from p tablesample bernoulli (50);
ERROR: TABLESAMPLE clause can only be applied to tables and materialized
views

Thanks,
Amit

Attachment Content-Type Size
0001-Partitioned-tables-support-tablesample.patch text/x-diff 3.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2017-02-22 07:53:45 Re: Replication vs. float timestamps is a disaster
Previous Message Robins Tharakan 2017-02-22 07:33:10 Re: Allow pg_dumpall to work without pg_authid