Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] tablesample with partitioned tables - Mailing list pgsql-hackers

From Amit Langote
Subject [HACKERS] tablesample with partitioned tables
Date
Msg-id 59af6590-8ace-04c4-c36c-ea35d435c60e@lab.ntt.co.jp
Whole thread Raw
Responses Re: [HACKERS] tablesample with partitioned tables  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view 
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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Attachment

pgsql-hackers by date:

Previous
From: Robins Tharakan
Date:
Subject: Re: [HACKERS] Allow pg_dumpall to work without pg_authid
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Replication vs. float timestamps is a disaster