PostgreSQL -- Function parameters are missing default specification.

8 views
Skip to first unread message

Faron Dutton

unread,
Apr 1, 2012, 9:58:20 AM4/1/12
to DB Solo
I have a function like this:

create function foo(
in a int4,
in b int4,
in c int4 default null
) returns setof foo_t as ...

The generated SQL is missing the default specifier for parameter c:

create function foo(
in a int4,
in b int4,
in c int4
) returns setof foo_t as ...

This causes a failure when updating other functions that only pass two
arguments.

Marko Hantula

unread,
Apr 8, 2012, 8:27:07 PM4/8/12
to db-...@googlegroups.com
This should be fixed now. Please download the latest from dbsolo.com/preview.

Marko

> --
> You received this message because you are subscribed to the Google Groups "DB Solo" group.
> To post to this group, send email to db-...@googlegroups.com.
> To unsubscribe from this group, send email to db-solo+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/db-solo?hl=en.
>

Reply all
Reply to author
Forward
0 new messages