HI,
I am getting problem while loading functions in postgresql. i am using liquibase 2. 0.1 version.
I wrote my function in one.sql file and i am calling that sql file in my changeSet like mentioned below.
below is my function:
– Function: cdrep()
– DROP FUNCTION cdrep();
CREATE OR REPLACE FUNCTION cdrep()
RETURNS int4 AS
’
declare
accno character(12);
rec record;
Begin
for rec in select acc_no from dgcd skip 1
loop
accno=rec.acc_no;
raise notice ‘acc_no %’ ,rec.acc_no;
update ppp1 set craccno=accno;
raise notice ‘acc_no %’ ,ppp1.craccno;
insert into dg1 select * from ppp1;
end loop;
return 1;
end;
’
LANGUAGE ‘plpgsql’ VOLATILE;
and tried to execute this in command line,got
<span
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
… 9 more
For more information, use the --logLevel flag)
any can help me in this ,
Thanks in advance