Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ViboQ-0000st-GK for pgsql-admin@arkaria.postgresql.org; Tue, 19 Nov 2013 03:17:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1ViboO-00056E-P7 for pgsql-admin@arkaria.postgresql.org; Tue, 19 Nov 2013 03:17:12 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhVrl-0006p4-Es for pgsql-admin@postgresql.org; Sat, 16 Nov 2013 02:44:09 +0000 Received: from nm29-vm1.bullet.mail.bf1.yahoo.com ([98.139.213.144]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VhVrd-0004gK-GN for pgsql-admin@postgresql.org; Sat, 16 Nov 2013 02:44:08 +0000 Received: from [66.196.81.174] by nm29.bullet.mail.bf1.yahoo.com with NNFMP; 16 Nov 2013 02:44:00 -0000 Received: from [98.139.212.247] by tm20.bullet.mail.bf1.yahoo.com with NNFMP; 16 Nov 2013 02:44:00 -0000 Received: from [127.0.0.1] by omp1056.mail.bf1.yahoo.com with NNFMP; 16 Nov 2013 02:44:00 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 294345.57142.bm@omp1056.mail.bf1.yahoo.com Received: (qmail 58736 invoked by uid 60001); 16 Nov 2013 02:44:00 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1384569840; bh=jNBLFCV0eKXNsVCfX84x7q2iXGelFVmck2hEsS9GE3Y=; 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:Content-Transfer-Encoding; b=Zvj/tqAAescVo2EkjAFf9Jtq50LAEZ/tQUXzZhFDRFkHgzUrX/uaxGK3VflmM5Xs5RWjaY7WcFTFWbybs+YK5qCRa+0YaEJN5fiwBBzv9FHVyZyL0IhxST64S3cRL3CrrmneNeNgkwm+2OLYhqYfH+pVHmIeKU9/j7rm9YBXfNU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.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:Content-Transfer-Encoding; b=o0M7Us28QO6a8k1ZXDJPhFGQpv6i4rlZEcFiLuFxsxTGEe+O4b7LXXg34lKbKnuqPQqjrYzek4dYm1GDdNnxloFeUdiKQVAzcMwrEkriy2g+nW02Y4NCbq+zt41fm2VjYckjb//XjEEMW8FhpI+rxQ3beUSmWDKMoTyO6et2ooY=; X-YMail-OSG: IZI..iEVM1nHmSjEkHluRNGgLeZT.Y9sWSGPExLnRtWWNjE b78bqeSHGzDAkRB5xprF3yiJNsLfuYgG2.knqtHoyHGkPjuvVJK2zkxB68oM 7irwCeFMp3b0AgT5JjGa08IEhPKFcULOdLu69rWhbV3VPDU0i0coLWNbp.MK tLQGNr3vLnoUQoIv6JpCeSgIDQsSKYDhpylMDC9n34ZECvNWoe9JPRhj1utI tG_hovkISbKkFDc5a.mTaoatddm1h.MgxriAMW0u6PiKdgxIXyTGzqf5Yt3v IdukVCTpGA0Xog6nNukL0zuom_lEhDi6k.8t9rVQQSNO6dZUrHQQGpoIhFUu MybAkxmEEMhPpvZiuowT8yEXnXN9Lqzp.ueclvm3HcZTB4.bMbnoEeXJcyfc Kpw1cW.80w1tGk_XJzw5PMKkFMI.s.SfXL9lGtVsUigOLmKb6yP.tRhsTHHn .5CvjRt0E88RYXSlpmodEFrl69oUi3fHC15DOrfSCXVYYJQoquq3qzIUieuI doo6F8atmPyIuqCO1BJSpi99uiqxh3q.opqEd9zypnw89ffv_SEaELZ2Dl3w nj8RoqrILY5nra4Yp66lZdi66hq.oKhUV.H0zQpWO0AZDqwecwKLOAzChYkT bCw-- Received: from [76.255.18.237] by web162903.mail.bf1.yahoo.com via HTTP; Fri, 15 Nov 2013 18:43:59 PST X-Rocket-MIMEInfo: 002.001, VGhhcmEgVmFkYWtrZXZlZWR1IDx0aGFyYWd2QHlhaG9vLmNvbT4gd3JvdGU6Cgo.IEJ5IGl0c2VsZiB0aGlzIHNxbCB3b3JrczoKCj4gU0VMRUNUIDAgRlJPTSBwZ19jbGFzcwo.wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgV0hFUkUgcmVsa2luZCA9ICdTJwo.wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIEFORCBvaWQgPSAoJ3B1YmxpYy4nIHx8IHF1b3RlX2lkZW50KCdoaWJlcm5hdGVfc2VxdWVuY2UnKSk6OnJlZ2NsYXNzOwo.Cj4gSG93ZXZlciB3aGVuIEkgY3JlYXRlIGEgZnVuY3Rpb24gZm8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.163.597 References: <1384543840.72953.YahooMailNeo@web125002.mail.ne1.yahoo.com> <1384544163.79352.YahooMailNeo@web125002.mail.ne1.yahoo.com> <1384545985.96990.YahooMailNeo@web162906.mail.bf1.yahoo.com> <1384549763.68859.YahooMailNeo@web125005.mail.ne1.yahoo.com> <52868E61.1000806@gmail.com> <1384556193.7870.YahooMailNeo@web125001.mail.ne1.yahoo.com> Message-ID: <1384569839.58633.YahooMailNeo@web162903.mail.bf1.yahoo.com> Date: Fri, 15 Nov 2013 18:43:59 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: checking if sequence exists To: Thara Vadakkeveedu , "pgsql-admin@postgresql.org" In-Reply-To: <1384556193.7870.YahooMailNeo@web125001.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -0.1 (/) 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 Thara Vadakkeveedu wrote: > By itself this sql works: > SELECT 0 FROM pg_class >=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 WHERE relkind =3D 'S' >=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 AND oid =3D ('public.' || qu= ote_ident('hibernate_sequence'))::regclass; > > However when I create a function for it and run it I see an error >=20 > create function chk_sequence() returns integer as $$ > BEGIN > IF EXISTS (SELECT 1 FROM pg_class >=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 WHERE relkind =3D 'S' >=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 AND oid =3D ('public.' || quote_id= ent('hibernate_sequence')))::regclass >=A0=A0 THEN >=A0=A0=A0=A0=A0=A0=A0=A0 return 1; >=A0=A0 ELSE >=A0 return 0; >=A0=A0=A0=A0 END IF; > END; > $$ language plpgsql; Move the cast to regclass inside one level of parentheses. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin