money.patch

text/plain

Download

Patch

Format: context

File	+	−
/home/alvherre/Code/pgsql/build/REL_10_STABLE/src/test/regress/results/create_table.out	1	5

*** /pgsql/source/REL_10_STABLE/src/test/regress/expected/create_table.out	2018-07-09 13:13:57.397491338 -0400
--- /home/alvherre/Code/pgsql/build/REL_10_STABLE/src/test/regress/results/create_table.out	2018-07-09 17:43:00.794556357 -0400
***************
*** 496,507 ****
  	a money
  ) PARTITION BY LIST (a);
  CREATE TABLE moneyp_10 PARTITION OF moneyp FOR VALUES IN (10);
- ERROR:  specified value cannot be cast to type money for column "a"
- LINE 1: ...EATE TABLE moneyp_10 PARTITION OF moneyp FOR VALUES IN (10);
-                                                                    ^
- DETAIL:  The cast requires a non-immutable conversion.
- HINT:  Try putting the literal value in single quotes.
  CREATE TABLE moneyp_10 PARTITION OF moneyp FOR VALUES IN ('10');
  DROP TABLE moneyp;
  -- immutable cast should work, though
  CREATE TABLE bigintp (
--- 496,503 ----
  	a money
  ) PARTITION BY LIST (a);
  CREATE TABLE moneyp_10 PARTITION OF moneyp FOR VALUES IN (10);
  CREATE TABLE moneyp_10 PARTITION OF moneyp FOR VALUES IN ('10');
+ ERROR:  relation "moneyp_10" already exists
  DROP TABLE moneyp;
  -- immutable cast should work, though
  CREATE TABLE bigintp (

======================================================================