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

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 (view raw, whole thread or download thread mbox)
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: 0001-Partitioned-tables-support-tablesample.patch
Description: text/x-diff (3.2 KB)

Responses

pgsql-hackers by date

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

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