BUG #14408: Schema not found error when 2 or more indices declared on temporary table - Mailing list pgsql-bugs

From vcolborn@gmail.com
Subject BUG #14408: Schema not found error when 2 or more indices declared on temporary table
Date
Msg-id 20161101192655.15987.25903@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14408: Schema not found error when 2 or more indices declared on temporary table
Re: BUG #14408: Schema not found error when 2 or more indices declared on temporary table
List pgsql-bugs
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDQwOApMb2dnZWQgYnk6ICAg
ICAgICAgIFZpY3RvciBDb2xib3JuCkVtYWlsIGFkZHJlc3M6ICAgICAgdmNv
bGJvcm5AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS42LjEKT3Bl
cmF0aW5nIHN5c3RlbTogICAoUmVkIEhhdCA0LjQuNy0xNiksIDY0LWJpdApE
ZXNjcmlwdGlvbjogICAgICAgIAoKSSdtIGZpbmRpbmcgdGhhdCB0aGlzIHJh
dGhlciBzaW1wbGUgcG9zdGdyZXNxbCA5LjYuMSBmdW5jdGlvbg0KDQpDUkVB
VEUgT1IgUkVQTEFDRSBGVU5DVElPTiB0cnlpbmdfdG9faW5kZXhfbWUoKQ0K
UkVUVVJOUyBWT0lEICBBUw0KJEJPRFkkDQogICAgQkVHSU4NCiAgICBDUkVB
VEUgVGVtcG9yYXJ5IFRBQkxFIHRlbXBfZGF0YV90b19pbmRleCAoIA0KICAg
ICAgICBpZCBJTlRFR0VSIE5PVCBOVUxMLCAgICANCiAgICAgICAgdGhpc19p
ZCBVVUlEIE5PVCBOVUxMLA0KICAgICAgICB0aGF0X2lkIHNtYWxsaW50IE5P
VCBOVUxMLA0KICAgICAgICBDT05TVFJBSU5UIGlkeF90ZW1wX2RhdGFfdG9f
aW5kZXhfdW5pcXVlDQogICAgICAgICAgICBVTklRVUUgKGlkLHRoaXNfaWQs
dGhhdF9pZCkgICAgIA0KICAgICk7IA0KICAgIENSRUFURSBJTkRFWCBpZHhf
dGVtcF9kYXRhX3RvX2luZGV4X3RoaXN0aGF0IE9OCnRlbXBfZGF0YV90b19p
bmRleCh0aGlzX2lkLHRoYXRfaWQpOyAgDQogICAgRFJPUCBUQUJMRSB0ZW1w
X2RhdGFfdG9faW5kZXg7DQpFTkQ7DQokQk9EWSQgTEFOR1VBR0UgcGxwZ3Nx
bCBWT0xBVElMRSBDT1NUIDEwMDsNCi0tU0VMRUNUIHRyeWluZ190b19pbmRl
eF9tZSgpOw0KDQppcyByZXN1bHRpbmcgaW4gYSBzY2hlbWEgIiIgZG9lcyBu
b3QgZXhpc3QgZXJyb3IuIFRoZSBleGFjdCBlcnJvciBpczoNCg0KRVJST1I6
ICBzY2hlbWEgIiIgZG9lcyBub3QgZXhpc3QNCkNPTlRFWFQ6ICBTUUwgc3Rh
dGVtZW50ICJDUkVBVEUgSU5ERVggaWR4X3RlbXBfZGF0YV90b19pbmRleF90
aGlzdGhhdCBPTgp0ZW1wX2RhdGFfdG9faW5kZXgodGhpc19pZCx0aGF0X2lk
KSINClBML3BnU1FMIGZ1bmN0aW9uIHRyeWluZ190b19pbmRleF9tZSgpIGxp
bmUgMTAgYXQgU1FMIHN0YXRlbWVudA0KKioqKioqKioqKiBFcnJvciAqKioq
KioqKioqICAgIA0KRVJST1I6IHNjaGVtYSAiIiBkb2VzIG5vdCBleGlzdA0K
U1FMIHN0YXRlOiAzRjAwMA0KQ29udGV4dDogU1FMIHN0YXRlbWVudCAiQ1JF
QVRFIElOREVYIGlkeF90ZW1wX2RhdGFfdG9faW5kZXhfdGhpc3RoYXQgT04K
dGVtcF9kYXRhX3RvX2luZGV4KHRoaXNfaWQsdGhhdF9pZCkiDQpQTC9wZ1NR
TCBmdW5jdGlvbiB0cnlpbmdfdG9faW5kZXhfbWUoKSBsaW5lIDEwIGF0IFNR
TCBzdGF0ZW1lbnQNCg0KYW5kIG9jY3VycyByZWxpYWJseSBvbiB0aGUgc2Vj
b25kIGFuZCBzdWJzZXF1ZW50IGV4ZWN1dGlvbnMuIEN1dC9QYXN0aW5nIHRo
ZQphYm92ZSBTUUwgY2h1bmsgcmVwcm9kdWNlcyB0aGUgZXJyb3IuLi5mb3Ig
bWUuIFF1aXRlIGludGVyZXN0ZWQgaWYgdGhhdCdzCm5vdCB0aGUgY2FzZSBl
bHNld2hlcmUuIEkgaGF2ZSB0aGUgZm9sbG93aW5nIGNsdWVzOg0KDQpJdCB3
aWxsIGVycm9yIGNvbnNpc3RlbnRseSBvbmNlIGl0cyBpbi4NCkl0IGFsd2F5
cyBpbmRpY2F0ZXMgdGhlICdDUkVBVEUgSU5ERVgnIGxpbmUgYXMgdGhlIGN1
bHByaXQgb2YgZXJyb3IuDQpEZWNsYXJpbmcgdGhlIHBnX3RlbXAgdGVtcG9y
YXJ5IHNjaGVtYSBhcyAnLi4uIE9OIHBnX3RlbXAudGVtcF9kYXRhX3RvX2lu
ZGV4Ci4uLicgaGFzIG5vIGVmZmVjdC4NCkkgZmluZCB0aGF0IGlmIEkgZHJv
cCB0aGUgZnVuY3Rpb24gYW5kIHJlY3JlYXRlIGl0LCBJJ2xsIGdldCBvbmUg
ZXhlY3V0aW9uCmFuZCB0aGVuIHRoZSBlcnJvcmVkIHN0YXRlIHdpbGwgb2Nj
dXIgYWdhaW4uDQpJbnNlcnRpbmcgcmVjb3JkcyBhbHNvIGhhZCBubyBlZmZl
Y3Qgb24gdGhlIGVycm9yIHN0YXRlLg0KSSBmaW5kIHRoYXQgcmVtb3Zpbmcg
ZWl0aGVyIGlkeF90ZW1wX2RhdGFfdG9faW5kZXhfdGhpc3RoYXQgb3IKaWR4
X3RlbXBfZGF0YV90b19pbmRleF91bmlxdWUgcmVzb2x2ZXMgdGhlIGlzc3Vl
Lg0KSXQgaW5kaWNhdGVzIHRoZSBuYW1lIG9mIHRoZSBub3QgZm91bmQgc2No
ZW1hIHRvIGJlICIiIG9yICIwTUF7U3RhcnQgb2YKVGV4dH0CIiBvciBzb21l
IHNpbWlsYXIgdmFyaWFudCB3aXRoIG5vbi12aXNpYmxlIGNoYXJhY3RlciB2
YWx1ZXMuDQpUcnVseSBhcHByZWNpYXRlIHlvdXIgdGhvdWdodHMuCgo=

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14407: pg_attribute shows old column names for indexes
Next
From: Jamie Koceniak
Date:
Subject: Re: BUG #14399: Order by id DESC causing bad query plan