RE : Fuctions in liquibase using postgresql data base

Liquibase Development
1

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

2

Hi,

i finally got solution for this,

if i use tag in my change set,it will load all triggers and functions.

3

Thank you for posting the fix you eventually found!