dbflute / dbflute-core

DBFlute core libraries for Java8
http://dbflute.seasar.org/
24 stars 18 forks source link

DBFlute Engine: ReplaceSchema dropping no-name function on PostgreSQL #191

Closed jflute closed 7 months ago

jflute commented 11 months ago

For example:

-- #df:begin#
create or replace function FN_NONAME_ARG_ADDING_DATE(date, integer) returns date
    language plpgsql
as
$$
begin
    return $1 + ($2::text || ' month')::interval;
end;
$$;
-- #df:end#
drop function FN_NONAME_ARG_ADDING_DATE($1 in date, $2 in int4)
Failed to drop the procedure: drop function FN_NONAME_ARG_ADDING_DATE($1 in date, $2 in int4)
...
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"

https://www.postgresql.org/docs/current/sql-dropfunction.html says says argument name is not related to function's identity so we can use dummy value

so use dummy argument name:

drop function fn_noname_arg_adding_date(df1 in date, df2 in int4)