X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CB79B9FB3FB for ; Thu, 31 Aug 2006 15:16:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44986-01 for ; Thu, 31 Aug 2006 15:16:34 -0300 (ADT) X-Greylist: delayed 18:32:09.500146 by SQLgrey- Received: from eciweb.eldocomp.com (smtp.eldocomp.com [205.159.99.39]) by postgresql.org (Postfix) with ESMTP id E1D0D9FA418 for ; Thu, 31 Aug 2006 15:16:33 -0300 (ADT) Received: by eciweb.eldocomp.com with XWall v3.36 ; Thu, 31 Aug 2006 11:16:31 -0700 From: Naomi Walker To: Tom Lane Cc: Alvaro Herrera , "pgsql-admin@postgresql.org" , William Bloom Subject: Re: Upgrading from 7.4 to 8.1 Date: Thu, 31 Aug 2006 11:16:30 -0700 X-Assembled-By: XWall v3.36 Message-ID: <44F7277E.2000205@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/358 X-Sequence-Number: 22901 Thank you! Yes, there was a bogus user with a name ^c, which we dropped. Tom Lane wrote: > Alvaro Herrera writes: >> What are the exact options? I tried to reproduce it here, using a 8.1 >> and 8.2 pg_dumpall, and a 7.4 server, and couldn't. >=20 >>> CREATE ROLE ""; >>> ALTER ROLE "" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN; >=20 >> This is weird anyway -- do you really have a role named "" (empty >> string)? >=20 > It's not "empty string", it's '\003' as shown by the failure: >=20 > query was: SELECT useconfig[1] FROM pg_shadow WHERE usename =3D E'\003' >=20 > The problem is evidently that appendStringLiteral tries to use E syntax > in an inappropriate context, ie, while talking to a server that doesn't > understand it. This is fixed in HEAD (by using appendStringLiteralConn) > but I'm not sure if there is any very good way to fix it in the back > branches. >=20 > In the short term, Naomi's best workaround is surely to drop or rename > that user ... it hardly seems likely that the name is anything but a > typo. >=20 > regards, tom lane --=20 ---------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ---------------------------------------------------------------------------- Far and away the best prize that life offers is the chance to work hard at work worth doing. - Theodore Roosevelt ---------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or= its Customers and is intended for use only by the individual or entity to w= hich it is addressed, and may contain information that is=C2=A0privileged, c= onfidential or exempt from disclosure under applicable law. If you are not t= he intended recipient or it appears that this e-mail has been forwarded to y= ou without proper authority, you are notified that any use or dissemination = of this information in any manner is strictly prohibited. In such cases, ple= ase notify us immediately at mailmaster@mphasis.com and delete this mail fro= m your records.