PL/SQL block error

From: Sivannarayanreddy <sivannarayanreddy(at)subexworld(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: PL/SQL block error
Date: 2011-02-16 08:42:54
Message-ID: 4D5B8E0E.5040101@subexworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)subexworld(dot)com
<mailto:email(dot)id(at)subexworld(dot)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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2011-02-16 09:07:25 Re: PL/SQL block error
Previous Message Jasen Betts 2011-02-15 23:32:50 Re: Determine length of numeric field