Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 06688650556
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 10 Jul 2008 06:31:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 24698-03 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 10 Jul 2008 06:31:08 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web53703.mail.re2.yahoo.com (web53703.mail.re2.yahoo.com
	[206.190.37.24]) by postgresql.org (Postfix) with SMTP id 6C42E65054C
	for <pgsql-admin@postgresql.org>; Thu, 10 Jul 2008 06:31:11 -0300 (ADT)
Received: (qmail 93532 invoked by uid 60001); 10 Jul 2008 09:31:09 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=6GJgJNK9cWtSbT6j4gd9qmRf5ELUIFMx2/ZMQ5lMrytk6qbHZDZSv2U2Uc5ywJw6jV7LBOshqY8Kmr21au2+eKi0bzZYGuMfNQS98qaNulC/T+CdGn57hAUV/rs2scIu/b8Lx2qpxwLIlStgZDz6qOwgm09kYoQxA6WNjGN/Kuc=;
Received: from [82.182.120.68] by web53703.mail.re2.yahoo.com via HTTP;
	Thu, 10 Jul 2008 02:31:09 PDT
X-Mailer: YahooMailWebService/0.7.199
Date: Thu, 10 Jul 2008 02:31:09 -0700 (PDT)
From: Dev <dev_hyd2001@yahoo.com>
Reply-To: dev_hyd2001@yahoo.com
Subject: Re: create role syntax
To: pgsql-admin@postgresql.org
In-Reply-To: <816024.45647.qm@web53707.mail.re2.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1834865212-1215682269=:93261"
Message-ID: <576938.93261.qm@web53703.mail.re2.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.859 tagged_above=0 required=5 tests=AWL=-1.238,
	FRT_ROLEX=3.096, HTML_MESSAGE=0.001
X-Spam-Level: *
X-Archive-Number: 200807/100
X-Sequence-Number: 29710

--0-1834865212-1215682269=:93261
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Well! answering my own question using " works !

/Dev


--- On Thu, 7/10/08, Dev <dev_hyd2001@yahoo.com> wrote:
From: Dev <dev_hyd2001@yahoo.com>
Subject: [ADMIN] create role syntax
To: pgsql-admin@postgresql.org
Date: Thursday, July 10, 2008, 10:30 AM

Hi,

=A0=A0=A0=A0=A0 Is it possible to have numbers as role names? I tried doing=
 something like=20
create role 22221 login createdb

but I get a syntax error, however if I have an alphabet before the number i=
t seems to work.

For example like=20

create role x22221 login createdb


/Dev




      =0A=0A=0A      
--0-1834865212-1215682269=:93261
Content-Type: text/html; charset=us-ascii

<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'>Well! answering my own question using " works !<br><br>/Dev<br><br><br>--- On <b>Thu, 7/10/08, Dev <i>&lt;dev_hyd2001@yahoo.com&gt;</i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Dev &lt;dev_hyd2001@yahoo.com&gt;<br>Subject: [ADMIN] create role syntax<br>To: pgsql-admin@postgresql.org<br>Date: Thursday, July 10, 2008, 10:30 AM<br><br><div id="yiv858975775"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">Hi,<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Is it possible to have numbers as role names? I tried doing something like <br>create role 22221 login createdb<br><br>but I get a
 syntax error, however if I have an alphabet before the number it seems to work.<br><br>For example like <br><br>create role x22221 login createdb<br><br><br>/Dev<br><br></td></tr></tbody></table><br>

      </div></blockquote></td></tr></table><br>

      
--0-1834865212-1215682269=:93261--