Horton

Re: BUG #14666: Question on money type as the key of partitioned table

Michael Paquier <michael.paquier@gmail.com>

View thread View on postgr.es
From: Michael Paquier <michael.paquier@gmail.com>
To: Amit Langote <amitlangote09@gmail.com>
Cc: tianbing@highgo.com, PostgreSQL mailing lists <pgsql-bugs@postgresql.org>
Date: 2017-05-26T20:29:06Z
Lists: pgsql-bugs 
On Wed, May 24, 2017 at 4:22 PM, Amit Langote <amitlangote09@gmail.com> wrote:
> Yep, looks like a bug; will look into it.

Cool.

Just mentioning... I found surprising to see that failing with a
partition error:
=# create table test(m money) partition by list(m);
CREATE TABLE
=#  create table test_1 partition of test for values in (10::money);
ERROR:  42601: syntax error at or near "::"
Likely the price to pay to get a minimal feature in 10.
-- 
Michael

Commits

  1. Docs: improve CREATE TABLE ref page's discussion of partition bounds.

  2. Code review focused on new node types added by partitioning support.