From: | Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | pg_upgrade tests failing on current master |
Date: | 2018-01-23 11:21:51 |
Message-ID: | a068eaac-ae92-6d97-15ed-7e33630df235@2ndquadrant.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
The current master HEAD fails pg_upgrade tests on my machine.
If I revert the "Move handling of database properties from pg_dumpall
into pg_dump." commit b3f8401205afdaf63cb20dc316d44644c933d5a1 the test
passes.
The error is:
pg_restore: creating RULE "public.rtest_emp rtest_emp_del"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5168; 2618 34331 RULE
rtest_emp rtest_emp_del mnencia
pg_restore: [archiver (db)] could not execute query: ERROR: invalid
input syntax for type money: "$0.00"
LINE 3: ... ("old"."ename", CURRENT_USER, 'fired'::"bpchar", '$0.00'::"...
^
Command was: CREATE RULE "rtest_emp_del" AS
ON DELETE TO "rtest_emp" DO INSERT INTO "rtest_emplog" ("ename",
"who", "action", "newsal", "oldsal")
VALUES ("old"."ename", CURRENT_USER, 'fired'::"bpchar",
'$0.00'::"money", "old"."salary");
I'm on OSX with locale "it_IT.UTF-8"
If I set LANG=C the problem disappears.
Regards,
Marco
--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco(dot)nenciarini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
From | Date | Subject | |
---|---|---|---|
Next Message | Etsuro Fujita | 2018-01-23 11:43:29 | Incorrect comments in partition.c |
Previous Message | Etsuro Fujita | 2018-01-23 11:13:52 | Re: list partition constraint shape |