Re: MySQL search query is not executing in Postgres DB - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id CA+U5nM+ZrEopxEYEw_d3aq87jHf9cshNyuAj4qFPMCfyLqZmCw@mail.gmail.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: MySQL search query is not executing in Postgres DB  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: MySQL search query is not executing in Postgres DB  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
On 29 August 2012 23:39, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> The main downside I can see is that code that used to work is likely
> to stop working as soon as someone creates a potential overloading
> situation.  Worse, the error message could be pretty confusing, since
> if you had been successfully calling f(smallint) with f(42), you'd get
> "f(integer) does not exist", not something like "f() is ambiguous",
> after adding f(float8) to the mix.  This seems related to the confusing
> changes in regression test cases that I got in my experiments yesterday.
> This may be sufficient reason to reject the idea, since the very last
> thing we need in this area is any degradation in the relevance of the
> error messages.

It would be useful if we issued a NOTICE when an ambiguity is
introduced, rather than when using it.

Like Bison's reporting of reduce conflicts.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: C-function, don't load external dll file
Next
From: Andrew Dunstan
Date:
Subject: Re: Database object names and libpq in UTF-8 locale on Windows