Re: Doing better at HINTing an appropriate column within errorMissingColumn() - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Date
Msg-id CAFj8pRDH7vqVpDP4GWw9CNS6sBrZjnKFgGwBjWchxMSxqV89Hg@mail.gmail.com
Whole thread Raw
In response to Re: Doing better at HINTing an appropriate column within errorMissingColumn()  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers



2014-03-28 9:22 GMT+01:00 Peter Geoghegan <pg@heroku.com>:
On Fri, Mar 28, 2014 at 1:00 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> I see only one risk - it can do some slowdown of exception processing.

I think it's unlikely that you'd see ERRCODE_UNDEFINED_COLUMN in
procedural code like that in practice. In any case it's worth noting
that I continually pass back a "max" to the Levenshtein distance
implementation, which is the current shortest distance observed. The
implementation is therefore not obliged to exhaustively find a
distance that is already known to be of no use. See commit 604ab0.

if it is related to ERRCODE_UNDEFINED_COLUMN then it should be ok (from performance perspective)

but second issue can be usage from plpgsql - where is mix SQL identifiers and plpgsql variables.

Pavel
 


--
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Next
From: Heikki Linnakangas
Date:
Subject: Re: trgm regex index peculiarity