Skip to content

if function have complicate default in parameter export stops  #9

@eltsov-da

Description

@eltsov-da

In one of our databases I found function with such header:
CREATE OR REPLACE FUNCTION kzn.calc_all_benef_itpr(
cz numeric,
dt date DEFAULT ('now'::text)::date,
g numeric DEFAULT NULL::numeric)
RETURNS integer
LANGUAGE 'plpgsql'

If I try export this function process stops with out any messages.
It's seems to me that this construction "dt date DEFAULT ('now'::text)::date," is to complicate for correct filename generation.
I understand that it's not good style of programming but I want to be able to export such functions before we correct them.
gitSQL_pg96_Functions

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions