Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhPBZ-00036f-Jl for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2013 19:36:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VhPBZ-00011f-3n for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2013 19:36:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhPBY-00011Z-AH for pgsql-admin@postgresql.org; Fri, 15 Nov 2013 19:36:08 +0000 Received: from nm15-vm6.bullet.mail.ne1.yahoo.com ([98.138.91.108]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhPBV-0007sR-Mo for pgsql-admin@postgresql.org; Fri, 15 Nov 2013 19:36:08 +0000 Received: from [98.138.100.112] by nm15.bullet.mail.ne1.yahoo.com with NNFMP; 15 Nov 2013 19:36:04 -0000 Received: from [98.138.101.179] by tm103.bullet.mail.ne1.yahoo.com with NNFMP; 15 Nov 2013 19:36:03 -0000 Received: from [127.0.0.1] by omp1090.mail.ne1.yahoo.com with NNFMP; 15 Nov 2013 19:36:03 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 985663.86767.bm@omp1090.mail.ne1.yahoo.com Received: (qmail 79510 invoked by uid 60001); 15 Nov 2013 19:36:03 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1384544163; bh=PLTcjV/pK0jUJAl0O4UycR/a+4wWK9+/xhvG+xdIE4U=; 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=3zV/FuDmJ1jHm1XhUCMDUuXaam8SFkkMaAu1uglCL7sKnCjf/AIEG3qoiGBoIQxOqPfuTfIBTe7bN2/OlCDRpjBo5uDdZJSmLuFvNg4dPGYyuf2mD8d7psNVvDGmMdXqDfOQlE8AceWW1LlINGuyxm8x3oPsLwUMfIq1V4FXgjg= 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=3ZcdEpfy/MezSM56Y+IWVkDbO2sb7JskfuWTPRNhZykVj1HhVQK27jsTf+KVuhGwhrn2bLOhs0IvoplnK+lIlYgS8hBnUXiYDAgAI4RAHukBE97vSkWVN1ffcI1XyfvGBnviY82GUZbVL2XyQgc5TcDAw8jyHMHt9cCMtuC08iE=; X-YMail-OSG: 8dfRs7QVM1nfHEcbXilrHwulglXGeDXbGQevaJU2aP2W2mn 3fwgKY85jpUl85WwOQBaj45WLUNFV1qkCdXAKngX42XkwytuKFL1aU3QbTHp 8xHqRja862vYiGT3fidLfqld3ClptBeHIT932Kszup7sPts3g4pqCMJwSxnK nzTz6iir4Na44J3kJgYuypJsu9koATyGkRletDtIL2U.ia0Kzgg1Y9R.f_eU 7FeHXY8.rFduTqrFIslumpTB.xSPxG2bi.b2sWf9Ed1k6HsrhA7fqYCeviUj Y8KkLIzdUwUmF58edbjeWd46YgJu_NvsCIaOpowWCcDDPhwtVebsDt1_Ggzn 8gj9DGBkLEDhU3iaTHG6UzTrgsGULvwYP3Xff7qUtotij.L3AnfqSgUltJIR HdFqsU_eZCRSppGFBimamllK6X2lR2JdHcJbt3JPpHpyQh6y1kZqRXKFIyni .FFtyRZSknsbRUuiffod9vhNp8ZnE9Tci9LtC6UII3NiBLBCr8aLMn4Tn1tK mMJFl1.9P8bAOVDa.HAcTIht3tXr23vP_yPtDEFU1OOi.YHFI6hXEHpzPuG1 ic0YScR8plVwWJRoaDtURK5CZoKoasiZxTPcb Received: from [50.241.80.25] by web125002.mail.ne1.yahoo.com via HTTP; Fri, 15 Nov 2013 11:36:03 PST X-Rocket-MIMEInfo: 002.001, SSB0cmllZCB0aGlzIGZyb20gcGdfYWRtaW4sIGJ1dCBJIGdldCBhIHN5bnRheCBlcnJvciAodW5leHBlY3RlZCBjaGFyYWN0ZXIpCsKgCklGIEVYSVNUUyAoU0VMRUNUIDAgRlJPTSBwZ19jbGFzcwrCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgV0hFUkUgcmVsa2luZCA9ICdTJwrCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIEFORCBvaWQ6OnJlZ2NsYXNzOjp0ZXh0ID0gJ3B1YmxpYy4nIHx8IHF1b3RlX2lkZW50KCdoaWJlcm5hdGVfc2VxdWVuY2UnKSkKwqAgVEhFTgrCoMKgwqAgUkFJU0UgRVhDRVBUSU8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.163.597 References: <1384543840.72953.YahooMailNeo@web125002.mail.ne1.yahoo.com> Message-ID: <1384544163.79352.YahooMailNeo@web125002.mail.ne1.yahoo.com> Date: Fri, 15 Nov 2013 11:36:03 -0800 (PST) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: checking if sequence exists To: Thara Vadakkeveedu , "pgsql-admin@postgresql.org" In-Reply-To: <1384543840.72953.YahooMailNeo@web125002.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-597570167-1276046685-1384544163=:79352" X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---597570167-1276046685-1384544163=:79352 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I tried this from pg_admin, but I get a syntax error (unexpected character)= =0A=A0=0AIF EXISTS (SELECT 0 FROM pg_class=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 WHERE relkind =3D 'S'=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 A= ND oid::regclass::text =3D 'public.' || quote_ident('hibernate_sequence'))= =0A=A0 THEN=0A=A0=A0=A0 RAISE EXCEPTION 'sequence public.% already exists!'= , 'hibernate_sequence=0AENF IF;=0A=A0=0AThanks.=0AFrom: Thara Vadakkeveedu = =0ATo: "pgsql-admin@postgresql.org" =0ASent: Friday, November 15, 2013 2:30 PM=0ASubject: Re: [ADMIN] = checking if sequence exists=0A=0A=0A=0AHow can we find out if a particular = sequence exists ? The idea is to check if sequence=A0first and if it does n= ot exist then create it...the goal is to do this when we deploy the applica= tion war...=0Athanks=0Atg ---597570167-1276046685-1384544163=:79352 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I trie= d this from pg_admin, but I get a syntax error (unexpected character)
 
IF EXISTS (SELECT 0 = FROM pg_class
         &nbs= p;   WHERE relkind =3D 'S'
      = ;         AND oid::regclass::text = =3D 'public.' || quote_ident('hibernate_sequence'))
  THEN
 = ;   RAISE EXCEPTION 'sequence public.% already exists!', 'hiberna= te_sequence
ENF IF;
 
Thanks.
From: Thara Vadakkeveedu <tharagv@yahoo.com>
= To: "pgsql-admin@postgresql= .org" <pgsql-admin@postgresql.org>
Sent: Friday, November 15, 2013 2:30 PM
Subject: Re: [ADMIN] checking if sequence= exists

How can we find out if a particular sequence exists ? The idea i= s to check if sequence first and if it does not exist then create it..= .the goal is to do this when we deploy the application war...
thanks
tg

 


---597570167-1276046685-1384544163=:79352--