Re: RFC: Query Planner making a distinction between Cross - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: RFC: Query Planner making a distinction between Cross
Date
Msg-id Pine.LNX.4.33.0402121358490.6043-100000@css120.ihs.com
Whole thread Raw
Responses Re: RFC: Query Planner making a distinction between Cross Database and Cross Schema ?
List pgsql-hackers
On Thu, 12 Feb 2004, Stef wrote:

> > Ummmm.  Postgresql doesn't natively support cross database queries...
> > 
> 
> I know, but it does schema's, and currently, the same
> notation is used to specify schema's as 'cross database'.
> 
> So the planner often reports 'cross-database not allowed'
> in areas where it should at least report 'cross-schema
> support is unavailable for this'
> 
> case in point, the example trigger. i would have expected
> deliberate schemaname.table during an insert to work, but
> instead the parser complains about cross-database.

I would think just changing the error message to "no schema by the name of 
suchandsuch found" would make it pretty clear.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed Query Planner TODO items
Next
From: Stef
Date:
Subject: Re: RFC: Query Planner making a distinction between Cross Database and Cross Schema ?