Re: [HACKERS] sorting a union over inheritance vs pathkeys

2014-06-26 Thread Michael Glaesemann
On Jun 25, 2014, at 22:14, Tom Lane t...@sss.pgh.pa.us wrote: I wrote: Michael Glaesemann g...@seespotcode.net writes: -- ERROR: could not find pathkey item to sort Hm ... I can reproduce that in 9.3 but it seems fine in 9.4 and HEAD. Don't know what's going on exactly. Interesting ---

[HACKERS] sorting a union over inheritance vs pathkeys

2014-06-25 Thread Michael Glaesemann
I’ve come across an issue when creating a union over tables which includes inheritance: CREATE TABLE events (event_id INT NOT NULL); -- CREATE TABLE CREATE UNIQUE INDEX events_event_id_key ON events (event_id); -- CREATE INDEX CREATE TABLE legacy_events (event_id INT NOT NULL); -- CREATE TABLE

Re: [HACKERS] sorting a union over inheritance vs pathkeys

2014-06-25 Thread Tom Lane
Michael Glaesemann g...@seespotcode.net writes: I’ve come across an issue when creating a union over tables which includes inheritance: CREATE TABLE events (event_id INT NOT NULL); -- CREATE TABLE CREATE UNIQUE INDEX events_event_id_key ON events (event_id); -- CREATE INDEX CREATE TABLE

Re: [HACKERS] sorting a union over inheritance vs pathkeys

2014-06-25 Thread Tom Lane
I wrote: Michael Glaesemann g...@seespotcode.net writes: -- ERROR: could not find pathkey item to sort Hm ... I can reproduce that in 9.3 but it seems fine in 9.4 and HEAD. Don't know what's going on exactly. Interesting --- it appears that commit a87c729153e372f3731689a7be007bc2b53f1410 is