From: Sivannarayanreddy <sivannarayanreddy@subexworld.com>
To: pgsql-sql@postgresql.org
Subject: PL/SQL block error
Date: Wed, 16 Feb 2011 14:12:54 +0530
Message-ID: <4D5B8E0E.5040101@subexworld.com> (raw)
Hello,
I am very new to the postgres sql, i am trying to execute below pl/sql
block in postgres but i am getting error *'ERROR: syntax error at or
near "integer" '*, Could some one help me in this regard
declare
v_count integer;
begin
select count(1) into v_count from pg_index inx where inx.indexrelid in
(select oid from pg_class where relname='action_pk' and relowner in
(select oid from pg_authid where rolname='postgres_ref'))
and inx.indrelid in
(select oid from pg_class where relname='action' and relowner in
(select oid from pg_authid where rolname='postgres_ref'));
if v_count = 0 then
execute immediate 'create unique index action_pk
on action(acn_id)';
end if;
end
*Sivannarayanareddy Nusum****| **System Analyst(Moneta GDO)*
Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli,
Bangalore -- 560037, India.
*Phone:*+91 80 6696 3371; *Mobile:*+91 9902065831*Fax:*+91 80 6696 3333;
*Email:*sivannarayanreddy@subexworld.com
<mailto:email.id@subexworld.com>; *URL:*www.subexworld.com
<http://www.subexworld.com/;
/Disclaimer: This e-mail is bound by the terms and conditions described
at //http://www.subexworld.com/mail-disclaimer.html/Attachments:
[image/gif] graphics1 (5.5K, ../4D5B8E0E.5040101@subexworld.com/3-graphics1)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sivannarayanreddy@subexworld.com
Subject: Re: PL/SQL block error
In-Reply-To: <4D5B8E0E.5040101@subexworld.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox