Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhPLe-0003Vy-7O for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2013 19:46:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VhPLd-0001L7-MG for pgsql-admin@arkaria.postgresql.org; Fri, 15 Nov 2013 19:46:33 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhPLc-0001Kz-Oy for pgsql-admin@postgresql.org; Fri, 15 Nov 2013 19:46:32 +0000 Received: from nm24-vm4.bullet.mail.ne1.yahoo.com ([98.138.91.184]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhPLZ-0005MG-TH for pgsql-admin@postgresql.org; Fri, 15 Nov 2013 19:46:32 +0000 Received: from [98.138.100.118] by nm24.bullet.mail.ne1.yahoo.com with NNFMP; 15 Nov 2013 19:46:28 -0000 Received: from [98.138.87.3] by tm109.bullet.mail.ne1.yahoo.com with NNFMP; 15 Nov 2013 19:46:28 -0000 Received: from [127.0.0.1] by omp1003.mail.ne1.yahoo.com with NNFMP; 15 Nov 2013 19:46:28 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 257187.80425.bm@omp1003.mail.ne1.yahoo.com Received: (qmail 86628 invoked by uid 60001); 15 Nov 2013 19:46:28 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1384544787; bh=Ly+TLg1DJWE6LH3qrlASftpBp5dWeRf3uAeawVgm3gM=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=r1XjRo9DCtIEWYjRNzL1e02taiE/4y63ZDuBUfVkckiF6UH52dECxzTWHODPiEUTkNxk7NWhiBYZ2W9o8DwQKjRFVr6QUIyIDYg8auGAGpzxi+GSvzf1dCe/v4MaqLSn0BHuD9RbaMlN0FGDc6jci59Rq7YDKn6AowEZnU7twSs= 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:Cc:In-Reply-To:MIME-Version:Content-Type; b=iQh+7svqKJvIybXB0aBY5Rll+TY8fcnCvK/mavLVaCYcHF/ZnglyD31I5DblRLo/eXdd16ifqBUzgQdoef/Cw/mHajaDF+pzpCjG2GOYvG+EVKN0B7uCpDmDziBJe/DAsdbFj9FuQ7zXFM6MR2Naqwb/9pXO7ZRZNd6H8hgGKq4=; X-YMail-OSG: h98tA.kVM1lTQhCOVH_eSu.VzOpikXrneMXRx.22m.cHacV VNdDLSL2JUyHaPjtTws9LPdryudytox1vSCX6MFThKo2HYnmTNvCZfxHxFgZ PgA8G9OdH9DFSVh9Icdx3ucqdTBpvIXu27R.TJhPYLOfchGSc33zcO.2Bz4s w1467GG_hvzxWfx.FF.lh2dt0sSMTqRa2sFXkas.qdq2IegWf_kdNwUjtMjh qANYdyU8V6ZdDVF45KdQzfvIcT64ucxy7.hjBMca_B16Xa8kLZ3P7ovzsSLV CvnW5gHifz0fre9OsR_GNXlmEQTRf9T5d5I9N6JKRMn9zgpqVpIiZv35OiO2 yTGCxRaHct1msTU4_dCnbKXqEr1CMImUWyHJ4NObPNINMRDPiC6sSoU13ddS tiJJ7dsCMgXSUIIQkqfRWvZhpmHeyB6nqvnCoqY5jvQWEvyWkxLMrZzmV0HL .BxuyrnYqKOp7.DSIm0RClmkc54_fRo1igQMzEoaN6nw.un6fgR807IMUfio 9FJjVELVGosGVRbHbrh6ugWEkka3sMMug3ghDWhDeLMrYl5b11ev3BOi3mhu DHuqqQBGux54V_mPeeZbz0Z9WE1z9mao- Received: from [50.241.80.25] by web125002.mail.ne1.yahoo.com via HTTP; Fri, 15 Nov 2013 11:46:27 PST X-Rocket-MIMEInfo: 002.001, VGhlIG5hbWUgb2YgdGhlIHNlcXVlbmNlIGlzIGhpYmVybmF0ZV9zZXF1ZW5jZS4gSSBhbHJlYWR5IGNoZWNrZWQgaW4gdGhlIHBnX2NsYXNzIHRhYmxlIHVuZGVyIGNhdGFsb2dzLi4KVGhhbmtzLAoKCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCkZyb206IFBheWFsIFNpbmdoIDxwYXlhbEBvbW5pdGkuY29tPgpUbzogVGhhcmEgVmFkYWtrZXZlZWR1IDx0aGFyYWd2QHlhaG9vLmNvbT4gCkNjOiAicGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmciIDxwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZz4BMAEBAQE- X-Mailer: YahooMailWebService/0.8.163.597 References: <1384543840.72953.YahooMailNeo@web125002.mail.ne1.yahoo.com> Message-ID: <1384544787.83230.YahooMailNeo@web125002.mail.ne1.yahoo.com> Date: Fri, 15 Nov 2013 11:46:27 -0800 (PST) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: checking if sequence exists To: Payal Singh Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-597570167-337623859-1384544787=:83230" X-Pg-Spam-Score: 0.7 (/) 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-337623859-1384544787=:83230 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable The name of the sequence is hibernate_sequence. I already checked in the pg= _class table under catalogs..=0AThanks,=0A=0A=0A___________________________= _____=0AFrom: Payal Singh =0ATo: Thara Vadakkeveedu =0ACc: "pgsql-admin@postgresql.org" =0ASent: Friday, November 15, 2013 2:38 PM=0ASubject: Re: [ADMIN] chec= king if sequence exists=0A=0A=0A=0A\d . will show = you columns, their types and the modifiers. If you look in the modifiers se= ction, you will be able to see existing sequences.=0A=0A=0APayal Singh,=0AO= mniTi Computer Consulting Inc.=0AJunior Database Architect,=0APhone:=A0240.= 646.0770=A0x 253=0A=0A=0A=0AOn Fri, Nov 15, 2013 at 2:30 PM, Thara Vadakkev= eedu wrote:=0A=0AHow can we find out if a particular se= quence exists ? The idea is to check if sequence=A0first and if it does not= exist then create it...the goal is to do this when we deploy the applicati= on war...=0A>thanks=0A>tg=0A>=0A>=A0 ---597570167-337623859-1384544787=:83230 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
The na= me of the sequence is hibernate_sequence. I already checked in the pg_class= table under catalogs..
Thanks,

From: Payal Singh <payal@omniti.com>= ;
To: Thara Vadakkeveedu= <tharagv@yahoo.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org> Sent: Friday, November 15,= 2013 2:38 PM
Subject: R= e: [ADMIN] checking if sequence exists

\d <schema_name>.<table_name> will show you colu= mns, their types and the modifiers. If you look in the modifiers section, y= ou will be able to see existing sequences.

Payal Singh,
OmniTi Computer Consulting Inc.
Junior Da= tabase Architect,
Phone: 240.646.0770 x 253


On Fri, Nov 15, 2013 at 2:30 PM, Thar= a Vadakkeveedu <tharagv@yahoo.com> wrote:
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-337623859-1384544787=:83230--