Re: Add LINE: hint when schemaname.typename is a non-existent schema - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Add LINE: hint when schemaname.typename is a non-existent schema
Date
Msg-id 11830.1426685574@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add LINE: hint when schemaname.typename is a non-existent schema  (Jeevan Chalke <jeevan.chalke@gmail.com>)
List pgsql-hackers
Jeevan Chalke <jeevan.chalke@gmail.com> writes:
> I am more concerned about this:

> 1.
> postgres=# create or replace function
> f1(a abc.test.id%type) returns int as
> $$ select 1; $$
> language sql;
> ERROR:  schema "abc" does not exist

> Is that expected?

Yes, or at least, if it's not what we want it's not this patch's fault.
That behavior is pre-existing.

> Also what about pushing setup_parser_errposition_callback() inside func_get_detail() as well, just to limit it for
namespacelookup?
 

Adding a pstate parameter to func_get_detail would be rather invasive;
not sure it's worth it.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Future directions for inheritance-hierarchy statistics
Next
From: Kouhei Kaigai
Date:
Subject: Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)