Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4899: Open parenthesis breaks query plan - Mailing list pgsql-bugs

From Peter Headland
Subject Re: BUG #4899: Open parenthesis breaks query plan
Date
Msg-id 71F491F5DA99604A80DE49424BF3D02B0C088B25@exchange8.actuate.com
Whole thread Raw
In response to BUG #4899: Open parenthesis breaks query plan  ("Peter Headland" <pheadland@actuate.com>)
Responses Re: BUG #4899: Open parenthesis breaks query plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
V2hpbGUgbm9vZGxpbmcgYXJvdW5kIHNvbWUgbW9yZSwgSSBmb3VuZCB0aGF0
IGEgY29tcGFyaXNvbiB0byAnKCknIGFsbG93cyB1c2Ugb2YgdGhlIGluZGV4
LCBhcyBkb2VzICcoYWJjKScgYW5kIGV2ZW4gJyhhKGIoYylkKWUpJy4gSXQg
YXBwZWFycyB0aGF0IG1pc21hdGNoZWQgb3Blbi9jbG9zZSBwYXJlbiBwYWly
cyB0cmlnZ2VyIHRoZSBidWcuIE9idmlvdXNseSBzb21ldGhpbmcgaXMgcGFy
c2luZyB0aGUgc3RyaW5nIGxpdGVyYWwgYW5kIG1pc2hhbmRsaW5nIHBhcmVu
dGhlc2VzLiBJIGRvbid0IHVuZGVyc3RhbmQgd2h5IHBhcmVudGhlc2VzIHNo
b3VsZCBiZSBzaWduaWZpY2FudCBpbnNpZGUgYSBzdHJpbmcgbGl0ZXJhbCBp
biB0aGUgZmlyc3QgcGxhY2UuDQoNCkFsc28sIGp1c3QgdG8gYmUgMTAwJSBj
bGVhciwgdGhlIG9wZW4gcGFyZW4gY2FuIGJlIGFueXdoZXJlIGluIHRoZSBz
dHJpbmcsIHNvIGEgY29tcGFyaXNvbiB0byAnYWJjZGVmZ2goaWprbG1ub3An
IHN0aWxsIHRyaWdnZXJzIHRoZSBidWcuDQoNCi0tIA0KUGV0ZXIgSGVhZGxh
bmQNCkFyY2hpdGVjdCAtIGUuUmVwb3J0cw0KQWN0dWF0ZSBDb3Jwb3JhdGlv
bg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogUGV0ZXIg
SGVhZGxhbmQgDQpTZW50OiBTYXR1cmRheSwgSnVseSAwNCwgMjAwOSAxODow
Mw0KVG86IHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IEJV
RyAjNDg5OTogT3BlbiBwYXJlbnRoZXNpcyBicmVha3MgcXVlcnkgcGxhbg0K
DQoNClRoZSBmb2xsb3dpbmcgYnVnIGhhcyBiZWVuIGxvZ2dlZCBvbmxpbmU6
DQoNCkJ1ZyByZWZlcmVuY2U6ICAgICAgNDg5OQ0KTG9nZ2VkIGJ5OiAgICAg
ICAgICBQZXRlciBIZWFkbGFuZA0KRW1haWwgYWRkcmVzczogICAgICBwaGVh
ZGxhbmRAYWN0dWF0ZS5jb20NClBvc3RncmVTUUwgdmVyc2lvbjogOC40LjAN
Ck9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cw0KRGVzY3JpcHRpb246ICAg
ICAgICBPcGVuIHBhcmVudGhlc2lzIGJyZWFrcyBxdWVyeSBwbGFuDQpEZXRh
aWxzOiANCg0KSW4gYSBtb2RlcmF0ZS1zaXplIHRhYmxlICh+NDAwLDAwMCBy
b3dzKSwgYW4gZXF1YWxpdHkgbWF0Y2ggb24gYW4gdW5pbmRleGVkDQp2YXJj
aGFyIGNvbHVtbiB0byBhIHN0cmluZyB0aGF0IGNvbnRhaW5zIGFuIG9wZW4g
cGFyZW50aGVzaXMgJygnIHByZXZlbnRzDQp0aGUgb3B0aW1pemVyIGZyb20g
dXNpbmcgYW4gb2J2aW91cyBpbmRleC4gQ2hhbmdpbmcgdGhlIG9wZW4gcGFy
ZW50aGVzaXMgdG8NCmFub3RoZXIgY2hhcmFjdGVyLCBzdWNoIGFzICcpJyBh
bGxvd3MgdGhlIG9idmlvdXMgaW5kZXggdG8gYmUgdXNlZC4gSSBoYXZlDQpi
ZWVuIHVuYWJsZSB0byByZXByb2R1Y2UgdGhpcyBvbiBzaW1wbGUgdGVzdCBk
YXRhIHNvIGZhciwgc28gaXQgaXMgb2J2aW91c2x5DQpmYWlybHkgc3VidGxl
Lg0KDQpBYnN0cmFjdCBleGFtcGxlIG9mIHRoZSBpc3N1ZToNCg0KbyB0YWJs
ZSB0IGhhcyBhIGNvbXBvc2l0ZSBpbmRleCBpIGNvbXByaXNpbmcgY29sdW1u
cyBjMSwgYzIsIGMzDQoNCm8gY29sdW1uIHQuYzQgaXMgbm90IGluZGV4ZWQN
Cg0KSWxsdXN0cmF0aW9uIG9mIHRoZSBxdWVyaWVzOg0KDQotLSBGdWxsIHRh
YmxlIHNjYW4NClNFTEVDVCBDT1VOVCgqKSBGUk9NIHQgV0hFUkUgdC5jMSA9
IDEyMyBBTkQgdC5jNCA9ICcoJzsNCg0KLS0gVXNlcyBpbmRleCBpDQpTRUxF
Q1QgQ09VTlQoKikgRlJPTSB0IFdIRVJFIHQuYzEgPSAxMjMgQU5EIHQuYzQg
PSAnKSc7DQoNCkkgYW0gcmVhbGx5IGhvcGluZyB0aGF0IHRoaXMgZGVmZWN0
IGNhbiBiZSBmb3VuZCBieSBpbnNwZWN0aW9uIG9mIHRoZQ0Kc291cmNlLCBi
ZWNhdXNlIHRyeWluZyB0byByZXByb2R1Y2UgaXQgaXMgZmFzdCBnZXR0aW5n
IG1lIG5vd2hlcmUuDQpVbmZvcnR1bmF0ZWx5LCB0aGUgZGF0YSBpbnZvbHZl
ZCBhcmUgY3VzdG9tZXIgY29uZmlkZW50aWFsLCBzbyBJIGNhbm5vdA0KcHJv
dmlkZSB0aGUgb3JpZ2luYWwgdGFibGUuDQo=

pgsql-bugs by date:

Previous
From: "Peter Headland"
Date:
Subject: BUG #4900: Query planner misses obvious optimization on ordered UNION DISTINCT
Next
From: Oleg Serov
Date:
Subject: Re: Diffrent column ordering after dump/restore tables with INHERITS