Re: [HACKERS] Namespace of array of user defined types is confused by the parser in insert? - Mailing list pgsql-general

From Andrew Dunstan
Subject Re: [HACKERS] Namespace of array of user defined types is confused by the parser in insert?
Date
Msg-id 4F96B450.9050609@dunslane.net
Whole thread Raw
In response to Re: [HACKERS] Namespace of array of user defined types is confused by the parser in insert?  (Krzysztof Nienartowicz <krzysztof.nienartowicz@gmail.com>)
List pgsql-general

On 04/24/2012 05:12 AM, Krzysztof Nienartowicz wrote:
>
> These types are qualified when created - the error does not happen on
> creation - there are two types in two different namespaces - it
> happens only on insert where it is not possible to qualify the type's
> namespace.
> It looks like a bug in the planner to me.
>

If it is please present a self-contained case demonstrating the bug,
preferably using psql rather than JDBC. Was all this done with the same
user / search path throughout the session (no connection pooling, for
example)? A complete log of the session (with log_statements,
log_connections and log_disconnections all turned on) might also help.

cheers

andrew



pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: how to make an SQL UPDATE from record returning function
Next
From: Emi Lu
Date:
Subject: Simple way to get missing number