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

2014-06-26 Thread Michael Glaesemann
On Jun 25, 2014, at 22:14, Tom Lane wrote: > I wrote: >> Michael Glaesemann 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 >

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

2014-06-25 Thread Tom Lane
I wrote: > Michael Glaesemann 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 why it works in

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

2014-06-25 Thread Tom Lane
Michael Glaesemann 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 legacy_events

[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 C