Обсуждение: BUG #14249: In FDW, variable not found in subplan target list
BUG #14249: In FDW, variable not found in subplan target list
От
wayne.warren@multiscalehn.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI0OQpMb2dnZWQgYnk6ICAg ICAgICAgIFdheW5lIFdhcnJlbgpFbWFpbCBhZGRyZXNzOiAgICAgIHdheW5l LndhcnJlbkBtdWx0aXNjYWxlaG4uY29tClBvc3RncmVTUUwgdmVyc2lvbjog OS42YmV0YTIKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTQKRGVzY3Jp cHRpb246ICAgICAgICAKCkkgaGF2ZSB3cml0dGVuIGEgZm9yZWlnbiBkYXRh IHdyYXBwZXIgdGhhdCB3b3JrcyB3aXRoIHZlcnNpb24gOS41LjIuIE5vdwp3 aXRoIDkuNmJldGEyIEkgcmVjZWl2ZSAiRVJST1I6IHZhcmlhYmxlIG5vdCBm b3VuZCBpbiBzdWJwbGFuIHRhcmdldCBsaXN0Igp3aGVuIEkgcmVmZXIgdG8g YSBjb2x1bW4gaW4gdGhlIFdIRVJFIGNsYXVzZSB0aGF0IGlzIG5vdCBhbHNv IGxpc3RlZCBhcyBhCnRhcmdldCBjb2x1bW46DQoNCm15ZGI9IyBzZWxlY3Qg cmVjb3JkX2lkLCBhZGRyX2NoZ191c2VyX2lkIGZyb20gc2lfZXB0XzQ3MA0K ICAgIHdoZXJlIGFkZHJfY2hnX2luc3RhbnQ9JzU0NDEzNDIxMjUnOw0KRVJS T1I6ICB2YXJpYWJsZSBub3QgZm91bmQgaW4gc3VicGxhbiB0YXJnZXQgbGlz dA0KDQpXaGVuIHRoZSBjb2x1bW4gaXMgaW5jbHVkZWQgaW4gdGhlIHRhcmdl dCBsaXN0LCB0aGUgY29ycmVjdCByZXN1bHRzIGFyZQpwcm9kdWNlZC4KCg==
wayne.warren@multiscalehn.com writes: > I have written a foreign data wrapper that works with version 9.5.2. Now > with 9.6beta2 I receive "ERROR: variable not found in subplan target list" > when I refer to a column in the WHERE clause that is not also listed as a > target column: > mydb=# select record_id, addr_chg_user_id from si_ept_470 > where addr_chg_instant='5441342125'; > ERROR: variable not found in subplan target list No such misbehavior is visible in file_fdw or postgres_fdw, so presumably your FDW is doing something wrong. There's not enough information here to say what; though a likely guess is that you're building a custom fdw_scan_tlist and forgetting to include Vars from restriction clauses in it. regards, tom lane