Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41872=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VhP6M-0002uj-Ms
 for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2013 19:30:47 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41872=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VhP6M-0006uE-73
 for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2013 19:30:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tharagv@yahoo.com>) id 1VhP6K-0006u3-Q5
 for pgsql-admin@postgresql.org; Fri, 15 Nov 2013 19:30:45 +0000
Received: from nm28-vm5.bullet.mail.ne1.yahoo.com ([98.138.91.250])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tharagv@yahoo.com>) id 1VhP6I-0007mX-06
 for pgsql-admin@postgresql.org; Fri, 15 Nov 2013 19:30:44 +0000
Received: from [98.138.101.130] by nm28.bullet.mail.ne1.yahoo.com with NNFMP;
 15 Nov 2013 19:30:40 -0000
Received: from [98.138.87.11] by tm18.bullet.mail.ne1.yahoo.com with NNFMP;
 15 Nov 2013 19:30:40 -0000
Received: from [127.0.0.1] by omp1011.mail.ne1.yahoo.com with NNFMP;
 15 Nov 2013 19:30:40 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 344600.28913.bm@omp1011.mail.ne1.yahoo.com
Received: (qmail 73782 invoked by uid 60001); 15 Nov 2013 19:30:40 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
 t=1384543840; bh=LSr2ap1zJzbSRxF8elXzftW7d6I0DiM+x2ZQlCJ2glQ=;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
 b=cBhSmUByeDpwjYMCXw/P+X0C3X6j9WSvJfLTUZQILMhvLbxA9zLgQOAL/TORqkZn1LVheIQkYPU1uFNxsabD6fcIG6+6h0CUIDZ79T8bvXwx4yOU3ngpiERjNhZ5y9vhzOKsLfH6bn+0KwjpGR2GpPvSfcMfTNBjzbxJoda08G4=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
 b=fw0FVvTaB7fD2HjljcmQxM6WOPS6E/94Q5MvBVn8kICrwMsiEZqgxUGdgWIyHE3eGOcdDCz6iLF3RXDTLc+ybAc32IMzdQLWqSkjM1J17zTGnBG9A4GsPJlHGKF7LlMKEqAcQsqxsICj4R45W+TI0Mm6kL+5TH9Xr80GTeQzH2M=;
X-YMail-OSG: 1ZBRViQVM1kXF5fZxCOrlfs4do0UMruFa4L2HVIgJUj5Juq
 ykPnOtemriPDnAOUVS9nr8virqEaaGN_3W8MHrElnTuKu6QLRI079DUGoCfj
 zX.tyepxBDA0jpabfKSl2NVLnhkUGcR0Y0uZbDjy3lKx2FmCrwOjMGl2aR6H
 xFrkBjykpqAxFvm3RuAAwxL4otuvA3ZucbMnajmvhCOGcVRp.nJUmN1Q6r12
 rFtp7mrGEF.EvLcoyMyGOb4epQktGvdcEj.PoFD_eW1aCv.GS66z2o2ecVUf
 AznGBKqC7ePw48ZMe2oslccQ6V92CLi_4teGodKU44Hfbfjzy6ZyKkdroxJm
 dZQvczojs6bowXHg89tHjQevG1kJjCCSYTQAeGXv5Q51SVHSP81q85rcGLzH
 dvNH88jHcMOiTwVYM0RzxLXJIvDIwGRaQYOSuHzH0rBrUPejRYlBNlTTmAph
 QWi2DiwZGjGCreAKc6DMdokWhCRDMCpdNdT7WWRqigG9ZBED5i.ZgWUYa.MD
 ni.L12WolQ3LzOcjfcx7n31eIUBzkrqJoTqVOWuhP9HcHtNB2.2eJMCCtl.C
 apnA22ShrB1XThRLOf3JZMSTpilyDr0ZOQGo-
Received: from [50.241.80.25] by web125002.mail.ne1.yahoo.com via HTTP;
 Fri, 15 Nov 2013 11:30:40 PST
X-Rocket-MIMEInfo: 002.001,
 SG93IGNhbiB3ZSBmaW5kIG91dCBpZiBhIHBhcnRpY3VsYXIgc2VxdWVuY2UgZXhpc3RzID8gVGhlIGlkZWEgaXMgdG8gY2hlY2sgaWYgc2VxdWVuY2XCoGZpcnN0IGFuZCBpZiBpdCBkb2VzIG5vdCBleGlzdCB0aGVuIGNyZWF0ZSBpdC4uLnRoZSBnb2FsIGlzIHRvIGRvIHRoaXMgd2hlbiB3ZSBkZXBsb3kgdGhlIGFwcGxpY2F0aW9uIHdhci4uLgp0aGFua3MKdGcBMAEBAQE-
X-Mailer: YahooMailWebService/0.8.163.597
References: 
 <CA+yMuNq+unyKgCrpfmmb2WK0=toMzqrx7491n=upM8Rrj3KtwQ@mail.gmail.com>
	<CAKoxK+5DvJYF3tor6=kJKdfhpxoui6PAFjuhy9WzHjZbngGDPQ@mail.gmail.com>
 <CA+yMuNqxZu+xZeGiD-fdC+QZK-x9+zg03X8xzDpBvQcVTncYxg@mail.gmail.com>
Message-ID: <1384543840.72953.YahooMailNeo@web125002.mail.ne1.yahoo.com>
Date: Fri, 15 Nov 2013 11:30:40 -0800 (PST)
From: Thara Vadakkeveedu <tharagv@yahoo.com>
Reply-To: Thara Vadakkeveedu <tharagv@yahoo.com>
Subject: Re: checking if sequence exists
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CA+yMuNqxZu+xZeGiD-fdC+QZK-x9+zg03X8xzDpBvQcVTncYxg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="-597570167-406868813-1384543840=:72953"
X-Pg-Spam-Score: 0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

---597570167-406868813-1384543840=:72953
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

How can we find out if a particular sequence exists ? The idea is to check =
if sequence=A0first and if it does not exist then create it...the goal is t=
o do this when we deploy the application war...=0Athanks=0Atg
---597570167-406868813-1384543840=:72953
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:He=
lveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;fo=
nt-size:14pt"><div style=3D"RIGHT: auto"><SPAN style=3D"RIGHT: auto">How ca=
n we find out if a particular sequence exists ? The idea is to check if seq=
uence&nbsp;first and if it does not exist then create it...the goal is to d=
o this when we deploy the application war...</SPAN></div>
<div style=3D"RIGHT: auto"><SPAN style=3D"RIGHT: auto">thanks</SPAN></div>
<div style=3D"RIGHT: auto"><SPAN style=3D"RIGHT: auto">tg</SPAN></div>
<div style=3D"RIGHT: auto"><BR>&nbsp;</div></div></body></html>
---597570167-406868813-1384543840=:72953--