pg_upgrade tests failing on current master

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

Responses

Browse pgsql-hackers by date

  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