On Thu, 2009-02-26 at 15:25 -0800, Josh Berkus wrote:
> That is, a custom type in a complex type declaration is explicitly
> schema-qualified, even when the schema in question is in the default
> schema_path. This is inconsistent with all other database objects,
> which use "SET search_path" to qualify the correct schemas.
>
Strange. However, I don't think setting the search path will suffice,
because the different types could come from different schemas in a way
that makes it impossible.
Functions are similar, actually. The argument list needs to specify
schema paths as well, if it's not in some expected place (I think it
does so for all schemas other than pg_catalog).
Regards,
Jeff Davis