Re: pg_upgrade tests failing on current master

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_upgrade tests failing on current master
Date: 2018-01-23 12:04:24
Message-ID: 20180123120424.GA5097@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 23, 2018 at 12:21:51PM +0100, Marco Nenciarini wrote:
> 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"

A couple of Windows buildfarm machines are complaining as well, like
whelk:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=whelk&dt=2018-01-22%2022%3A41%3A06

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4871; 2618 34331 RULE rtest_emp rtest_emp_del pgbf
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'::"...
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Abinaya k 2018-01-23 12:10:22 Regarding ambulkdelete, amvacuumcleanup index methods
Previous Message Pavel Stehule 2018-01-23 11:52:04 Re: [HACKERS] proposal - Default namespaces for XPath expressions (PostgreSQL 11)