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

The following bug has been logged on the website:

Bug reference:      14666
Logged by:          tian bing
Email address:      tianbing@highgo.com
PostgreSQL version: 10beta1
Operating system:   CentOS 6.4（64bits）
Description:

Hi,
When I use the money type as the key to create the partition table as
follows:

postgres=# create table test(m money) partition by list(m);
CREATE TABLE
postgres=# create table test_1 partition of test for values in (10);
CREATE TABLE

Partition bounds without apostrophe can be createed, but it store the null
value，not '10' value.

In fact, Correct grammar for creating partition is with apostrophe like
this:
postgres=# create table test_1 partition of test for values in ('10');

But the first creating partition without apostrophe should report an error
like "ERROR:  operator does not exist: money = integer"  as adding a check
constraint.

Looking forward to your reply.


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