Re: On partitioning - Mailing list pgsql-hackers

From Robert Haas
Subject Re: On partitioning
Date
Msg-id CA+TgmoaA18DL8SG51tDQ=wjQBAqb658cR1TSV3diLmk_x9iRzQ@mail.gmail.com
Whole thread Raw
In response to Re: On partitioning  ("Amit Langote" <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: On partitioning
List pgsql-hackers
On Sun, Dec 14, 2014 at 9:12 PM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> This means if a user puts arbitrary expressions in a partition definition, say,
>
> ... FOR VALUES  extract(month from current_date) TO extract(month from current_date + interval '3 months'),
>
> we make sure that those expressions are pre-computed to literal values.

I would expect that to fail, just as it would fail if you tried to
build an index using a volatile expression.

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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Logical Decoding follows timelines
Next
From: Jeff Janes
Date:
Subject: Re: pgbench -f and vacuum