X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4351FD99D6 for ; Mon, 10 Oct 2005 09:05:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94080-01 for ; Mon, 10 Oct 2005 12:05:46 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 3A8F3D80DD for ; Mon, 10 Oct 2005 09:05:48 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j9AC5kLs094082 for ; Mon, 10 Oct 2005 12:05:46 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j9ABq2d1047277 for pgsql-admin@postgresql.org; Mon, 10 Oct 2005 11:52:02 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: Update - pg_dumpall money problem Date: Mon, 10 Oct 2005 13:52:22 +0200 Organization: Hub.Org Networking Services Lines: 24 Message-ID: References: <200510101225.27874.gary.stainburn@ringways.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <200510101225.27874.gary.stainburn@ringways.co.uk> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.44 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.380] X-Spam-Level: X-Archive-Number: 200510/108 X-Sequence-Number: 19180 ..and I guess using custom format (-F c -Z 9) might be saver, because a newer pg_restore binary then might have a chance to correct things, depending on the server version it is used against. On 10.10.2005 13:25, Gary Stainburn wrote: > I'm trying to move an existing setup on a 7.2 system to another existing > box running 7.4. > > I've done a pg_dumpall and then imported that to the new system but a > copy is failing with the following: > > psql:/backups/eddie_pg_dumpall.sql:3076: ERROR: invalid input syntax > for type money: "£3.18" > CONTEXT: COPY invoices, line 1, column net: "£3.18" > > I asume that this is because 7.2 includes the currency sign, and 7.4 > doesn't like it. > > How do I sptop 7.2 including it, or make 7.4 allow it? -- Regards, Hannes Dorbath