Thread: [BUGS] BUG #14667: Question on money type as the key of partitioned table
[BUGS] BUG #14667: Question on money type as the key of partitioned table
From
csjy_tsb@163.com
Date:
The following bug has been logged on the website: Bug reference: 14667 Logged by: tian bing Email address: csjy_tsb@163.com PostgreSQL version: 10beta1 Operating system: centos6.4 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