Re: Please correct/improve wiki page about abbreviated keys bug - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Please correct/improve wiki page about abbreviated keys bug
Date
Msg-id CAM3SWZStgwpCEOggiXAhAYnkn1Om4R5zeKho22EB+6-XCDzrxA@mail.gmail.com
Whole thread Raw
In response to Re: Please correct/improve wiki page about abbreviated keys bug  (Josh berkus <josh@agliodbs.com>)
List pgsql-hackers
On Wed, Mar 30, 2016 at 6:23 PM, Josh berkus <josh@agliodbs.com> wrote:
> Based on that concept, I wrote a query which is now on the wiki page.
> Please fix it if it's not showing what we want it to show.

Sorry, I got caught up with something last night. I did this this
morning Pacific time.

I've made a number of passes over this. I've listed more non-affected
cases, since there are a number of non-obvious cases that are not at
risk, and fixed-up the SQL query, which didn't seem to be doing the
right thing about default collations or domains. I also made it
explicit that non-leading column indexes are not affected (although
that's just mentioned in passing when discussing the SQL query, as
it's a bit esoteric).

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: improving GROUP BY estimation
Next
From: Thomas Munro
Date:
Subject: Re: So, can we stop supporting Windows native now?