PostgreSQL -- Function return type is missing schema declaration.

[Faron Dutton]

The generated SQL for PostgreSQL does not contain the schema
declaration on a function's return type. For example,

create type foo.bar_t as (a int4, b int4);

create function foo.bar() returns setof bar_t as ...

which should be


create function foo.bar() returns setof foo.bar_t as ...
^^^

[Marko Hantula]

Is this in reference to the schema compare tool or the schema scripting tool?

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.
>

[Faron Dutton]

I am not sure. I just downloaded DB Solo yesterday for evaluation.

I have compared two schemata and generated a change script. It is the
script that is faulty.

[Marko Hantula]

This should be fixed now. The return type is qualified with the schema
name, as long as the 'Include schema name in statements' option is
selected.

You can find the fixed version in dbsolo.com/preview.

Marko