Re: [BUGS] BUG #14666: Question on money type as the key ofpartitioned table - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: [BUGS] BUG #14666: Question on money type as the key ofpartitioned table
Date
Msg-id CAB7nPqRwZ8STFAE-0jXzNqr+naOcYrN8HXKW0V21ARbTifK7ew@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14666: Question on money type as the key ofpartitioned table  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: [BUGS] BUG #14666: Question on money type as the key of partitioned table  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


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

pgsql-bugs by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: [BUGS] BUG #14635: Query is executed slower on hot standby slavedatabase then on master database
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14637: Tests fail with pl_PL.UTF-8 locale