Обсуждение: BUG #14219: rules vs. FK optimization: ERROR: no relation entry for relid 2

Поиск
Список
Период
Сортировка

BUG #14219: rules vs. FK optimization: ERROR: no relation entry for relid 2

От
andrew@tao11.riddles.org.uk
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIxOQpMb2dnZWQgYnk6ICAg
ICAgICAgIEFuZHJldyBHaWVydGgKRW1haWwgYWRkcmVzczogICAgICBhbmRy
ZXdAdGFvMTEucmlkZGxlcy5vcmcudWsKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5
LjZiZXRhMgpPcGVyYXRpbmcgc3lzdGVtOiAgIGFueQpEZXNjcmlwdGlvbjog
ICAgICAgIAoKKE15IGFuYWx5c2lzIG9mIGEgYnVnIG9yaWdpbmFsbHkgcmVw
b3J0ZWQgb24gSVJDOyBwbGVhc2UgQ0MgZGF2aWQuY2x5bWVyIGF0CnZpc3Rh
c2hhcmUuY29tKQ0KDQpJIGNvbnN0cnVjdGVkIHRoaXMgdGVzdCBjYXNlIGJh
c2VkIG9uIHRoZSBvcmlnaW5hbCByZXBvcnQ6DQoNCmNyZWF0ZSB0YWJsZSB0
MSAoYSBpbnRlZ2VyIHByaW1hcnkga2V5LCBiIHRleHQpOw0KY3JlYXRlIHRh
YmxlIHQyIChhIGludGVnZXIgcHJpbWFyeSBrZXksIGIgaW50ZWdlciByZWZl
cmVuY2VzIHQxKTsNCmNyZWF0ZSBydWxlIHIxIGFzIG9uIGRlbGV0ZSB0byB0
MSBkbyBkZWxldGUgZnJvbSB0MiB3aGVyZSB0Mi5iPW9sZC5hOw0KDQpkZWxl
dGUgZnJvbSB0MSB3aGVyZSBhPTE7DQpFUlJPUjogIG5vIHJlbGF0aW9uIGVu
dHJ5IGZvciByZWxpZCAyDQoNClRoZSBlcnJvciBpcyBjb21pbmcgZnJvbSBt
YXRjaF9mb3JlaWduX2tleXNfdG9fcXVhbHMsIGJ1dCBJIGhhdmVuJ3QgeWV0
CmludmVzdGlnYXRlZCBmdXJ0aGVyLgoK

Re: BUG #14219: rules vs. FK optimization: ERROR: no relation entry for relid 2

От
Tom Lane
Дата:
andrew@tao11.riddles.org.uk writes:
> create table t1 (a integer primary key, b text);
> create table t2 (a integer primary key, b integer references t1);
> create rule r1 as on delete to t1 do delete from t2 where t2.b=old.a;
> delete from t1 where a=1;
> ERROR:  no relation entry for relid 2

Fixed, thanks for report!

            regards, tom lane