pg_upgrade tests failing on current master - Mailing list pgsql-hackers

From Marco Nenciarini
Subject pg_upgrade tests failing on current master
Date
Msg-id a068eaac-ae92-6d97-15ed-7e33630df235@2ndquadrant.it
Whole thread Raw
Responses Re: pg_upgrade tests failing on current master
Re: pg_upgrade tests failing on current master
List 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.nenciarini@2ndQuadrant.it | www.2ndQuadrant.it


Attachment

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: list partition constraint shape
Next
From: Etsuro Fujita
Date:
Subject: Incorrect comments in partition.c