| From: | tianbing(at)highgo(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14666: Question on money type as the key of partitioned table |
| Date: | 2017-05-24 02:45:50 |
| Message-ID: | 20170524024550.29935.14396@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14666
Logged by: tian bing
Email address: tianbing(at)highgo(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-05-24 02:47:07 | Re: [HACKERS] Concurrent ALTER SEQUENCE RESTART Regression |
| Previous Message | Justin Muise | 2017-05-23 15:25:37 | Re: BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols |