Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 98D661337B64;
	Fri, 29 Oct 2010 01:58:33 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 55100-04; Fri, 29 Oct 2010 04:58:26 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com
 [74.125.83.46])
	by mail.postgresql.org (Postfix) with ESMTP id CB0561336971;
	Fri, 29 Oct 2010 01:58:25 -0300 (ADT)
Received: by gwj21 with SMTP id 21so1749484gwj.19
	for <multiple recipients>; Thu, 28 Oct 2010 21:58:24 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:content-type;
	bh=KtevIfGbBWQ20P2PDflxFWOgIBL2LCyZKfdI450pVRI=;
	b=lcJlqP3hLp9ao/8Q8D+LKl5vQ/hS4dk1kaa1zB4YXKQ2hMFkf6fwfuCvIEGFqRsjZT
	NAfY5z9wo6WmSx8bp5lfkl9W0cvLvt5i/+0qG6+X10smdGO2sn7y+l0a8axr7jXDN48+
	/GyV+tHUI0DAGCXqm5c5bxvUVnM6rf2Pp36eU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=rKF+KQ6Ab6euBtJIhkJBgr6VkZtxnFVxJGg3nPRJUUTgAb0lCNpI+95IuCX4NQIUUI
	VtnxnNOIKXF77g9iCRWSztoyWAwH+yKYLFku74I8/P0QJN5++6uLNnzz5tOWN5TJrIF2
	MzuB31BgUX7sLgXALjlWfOuga2eJcmrJIPo/s=
MIME-Version: 1.0
Received: by 10.91.7.12 with SMTP id k12mr3810446agi.197.1288328304710; Thu,
	28 Oct 2010 21:58:24 -0700 (PDT)
Received: by 10.91.219.15 with HTTP; Thu, 28 Oct 2010 21:58:24 -0700 (PDT)
In-Reply-To: <AANLkTimArej9_0ko8piTWsoW9mrsdwOUKJs2cNyLTEuf@mail.gmail.com>
References: <AANLkTimArej9_0ko8piTWsoW9mrsdwOUKJs2cNyLTEuf@mail.gmail.com>
Date: Fri, 29 Oct 2010 10:28:24 +0530
Message-ID: <AANLkTim-ZxOQStJenijn2UgMomM__PoFYKMrUzFeyE5x@mail.gmail.com>
Subject: Re: How to Convert Integer to Serial
From: venkat <ven.tammineni@gmail.com>
To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=00163630ee73f4d71f0493ba4ec5
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201010/1039
X-Sequence-Number: 168951

--00163630ee73f4d71f0493ba4ec5
Content-Type: text/plain; charset=ISO-8859-1

Dear All,

  I got the solution... Here is my query

ALTER TABLE DemoTable  ALTER gid TYPE INT2;

Thanks again....


On Fri, Oct 29, 2010 at 10:18 AM, venkat <ven.tammineni@gmail.com> wrote:

> Dear All,
>
>   I want to convert integer datatype to serial datatype.. is that
> possible.Please let me know.
>
> Thanks and Regards,
>
> Ven
>

--00163630ee73f4d71f0493ba4ec5
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<font color=3D"#000099">Dear All,</font><div><font color=3D"#000099"><br></=
font></div><div><font color=3D"#000099">=A0=A0I got the solution... Here is=
 my query</font></div><div><font color=3D"#000099"><br></font></div><div><f=
ont class=3D"Apple-style-span" color=3D"#000099">ALTER TABLE DemoTable =A0A=
LTER gid TYPE INT2;</font></div>
<div><font class=3D"Apple-style-span" color=3D"#000099"><br></font></div><d=
iv><font class=3D"Apple-style-span" color=3D"#000099">Thanks again....</fon=
t></div><div><font color=3D"#000099"><br></font><br><div class=3D"gmail_quo=
te">On Fri, Oct 29, 2010 at 10:18 AM, venkat <span dir=3D"ltr">&lt;<a href=
=3D"mailto:ven.tammineni@gmail.com">ven.tammineni@gmail.com</a>&gt;</span> =
wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><font color=3D"#000099">Dear All,</font><di=
v><font color=3D"#000099"><br></font></div><div><font color=3D"#000099">=A0=
=A0I want to convert integer datatype to serial datatype.. is that possible=
.Please let me know.</font></div>
<div><font color=3D"#000099"><br>
</font></div><div><font color=3D"#000099">Thanks and Regards,</font></div><=
div><font color=3D"#000099"><br></font></div><div><font color=3D"#000099">V=
en</font></div>
</blockquote></div><br></div>

--00163630ee73f4d71f0493ba4ec5--