From: | Ashish Karalkar <ashish_karalkar(at)yahoo(dot)com> |
---|---|
To: | slony <pgsql-general(at)postgresql(dot)org> |
Subject: | error in open cursor |
Date: | 2007-01-12 13:12:32 |
Message-ID: | 20070112131232.21026.qmail@web31604.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello all,
I am getting a syntax error near open cursor,
can anybody please point me what is missing. i am
using Postgresql 8.2
CREATE OR REPLACE FUNCTION
sp_gen_foreign_keys_tables(OUT par_result integer, OUT
par_childtables text, IN par_colname character varying
, IN par_colvalue integer) AS
$BODY$
DECLARE
tablename varchar(300);
columnname varchar(300);
countno integer;
curfroeign cursor (columnname varchar(300)) is select
distinct(fk_relation),fk_column from foreign_keys
where pk_relation in (select pk_relation from
foreign_keys where pk_column=columnname);
var_str1 varchar(300);
BEGIN
open curforeign(par_colname);
FETCH curforeign INTO tablename,columnname;
var_str1:='select count(*) into'||countno||'from'
||tablename || 'where' ||columnname||'='||parcolvalue;
execute var_str1;
if countno >0 then
par_childtables:=par_childtables || ',' ||tablename;
endif ;
close curfroeign ;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Evgeny Gridasov | 2007-01-12 13:23:06 | WAL question |
Previous Message | Gellert, Andre | 2007-01-12 13:08:24 | Re: Need setup help for Postgresql 8.1.3 on Solaris 10 |