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/
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 |