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
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) |