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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: tianbing(at)highgo(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14666: Question on money type as the key of partitioned table
Date: 2017-05-26 20:29:06
Message-ID: CAB7nPqRwZ8STFAE-0jXzNqr+naOcYrN8HXKW0V21ARbTifK7ew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, May 24, 2017 at 4:22 PM, Amit Langote <amitlangote09(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-05-28 18:53:39 Re: BUG #14637: Tests fail with pl_PL.UTF-8 locale
Previous Message Haribabu Kommi 2017-05-26 17:12:45 Re: BUG #14635: Query is executed slower on hot standby slave database then on master database