Postgres Pro
Downloads
Home   >   mailing lists

Fwd: plpgsql plan caching allowing invalid data to enter table? - Mailing list pgsql-bugs

From Joe Van Dyk
Subject Fwd: plpgsql plan caching allowing invalid data to enter table?
Date
Msg-id CACfv+p+G_sgmAVymrBPKE8f3rA4X6+20FVGVH9vVq8a=knfaww@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Tree view 
SXQncyBsb29raW5nIGxpa2UgSSBjYW4gdXNlIGEgcGxwZ3NxbCBmdW5jdGlvbiB0byBpbnNlcnQg
ZGF0YSBpbnRvIGEgdGFibGUNCnRoYXQgdmlvbGF0ZXMgYSBkb21haW4gY29uc3RyYWludC4gSXMg
dGhpcyBhIGtub3duIHByb2JsZW0/DQoNClNlc3Npb24gMToNCg0KY3JlYXRlIGRvbWFpbiBteV9k
b21haW4gdGV4dCBjaGVjayAobGVuZ3RoKHZhbHVlKSA+IDIpOw0KY3JlYXRlIHRhYmxlIG15X3Rh
YmxlIChuYW1lIG15X2RvbWFpbik7DQoNCmNyZWF0ZSBmdW5jdGlvbiBmKHRleHQpIHJldHVybnMg
dm9pZCBhcyAkJA0KZGVjbGFyZSBteV92YXIgbXlfZG9tYWluIDo9ICQxOw0KYmVnaW4NCiAgIGlu
c2VydCBpbnRvIG15X3RhYmxlIHZhbHVlcyAobXlfdmFyKTsNCmVuZCAkJCBsYW5ndWFnZSBwbHBn
c3FsOw0KDQpTZXNzaW9uIDI6DQpzZWxlY3QgZigndGVzdCcpOw0KZGVsZXRlIGZyb20gbXlfdGFi
bGU7DQotLSBLZWVwIHNlc3Npb24gb3BlbiENCg0KU2Vzc2lvbiAxOg0KYWx0ZXIgZG9tYWluIG15
X2RvbWFpbiBkcm9wIGNvbnN0cmFpbnQgbXlfZG9tYWluX2NoZWNrOw0KYWx0ZXIgZG9tYWluIG15
X2RvbWFpbiBhZGQgY29uc3RyYWludCBteV9kb21haW5fY2hlY2sgY2hlY2sgKGxlbmd0aCh2YWx1
ZSkNCj4gNSk7DQoNClNlc3Npb24gMjoNCnNlbGVjdCBmKCd0ZXN0Jyk7DQotLSBUaGlzIHdvcmtz
LCBidXQgaXQgc2hvdWxkIGZhaWwuDQotLSBJIGhhdmUgYSBjb25zdHJhaW50IG9mIG1vcmUgdGhh
biA1IGNoYXJhY3RlcnMgb24gdGhlIGRvbWFpbi4NCi0tIEJ1dCBJIGNhbiBpbnNlcnQgYSByb3cg
d2l0aCA0IGNoYXJhY3RlcnMuDQoNCg0KDQpBcyB5b3UgY2FuIHNlZSBiZWxvdywgSSBoYXZlIGRh
dGEgaW4gbXlfdGFibGUgdGhhdCdzIHZpb2xhdGluZyB0aGUgZG9tYWluJ3MNCmNvbnN0cmFpbnQg
b2YgYmVpbmcgbG9uZ2VyIHRoYW4gNSBjaGFyYWN0ZXJzLg0KDQoNCiMgc2VsZWN0ICogZnJvbSBt
eV90YWJsZTsNCiBuYW1lDQrilIDilIDilIDilIDilIDilIANCiB0ZXN0DQooMSByb3cpDQoNCg0K
IyBcZCsgbXlfdGFibGUNCiAgICAgICAgICAgICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMubXlf
dGFibGUiDQogQ29sdW1uIOKUgiAgIFR5cGUgICAg4pSCIE1vZGlmaWVycyDilIIgU3RvcmFnZSAg
4pSCIFN0YXRzIHRhcmdldCDilIIgRGVzY3JpcHRpb24NCuKUgOKUgOKUgOKUgOKUgOKUgOKUgOKU
gOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKU
gOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKU
gOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKU
gOKUgOKUgOKUgOKUgOKUgOKUgOKUgA0KIG5hbWUgICDilIIgbXlfZG9tYWluIOKUgiAgICAgICAg
ICAg4pSCIGV4dGVuZGVkIOKUgiAgICAgICAgICAgICAg4pSCDQpIYXMgT0lEczogbm8NCg0KDQoj
IFxkRCBteV9kb21haW4NCiAgICAgICAgICAgICAgICAgICAgICAgICBMaXN0IG9mIGRvbWFpbnMN
CiBTY2hlbWEg4pSCICAgTmFtZSAgICDilIIgVHlwZSDilIIgTW9kaWZpZXIg4pSCICAgICAgICAg
ICBDaGVjaw0K4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA
4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA
4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA
4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQogcHVibGljIOKUgiBteV9kb21h
aW4g4pSCIHRleHQg4pSCICAgICAgICAgIOKUgiBDSEVDSyAobGVuZ3RoKFZBTFVFKSA+IDUpDQoo
MSByb3cpDQo=

pgsql-bugs by date:

Previous
From: lalbin@fhcrc.org
Date:
Subject: BUG #8291: postgres_fdw does not re-read USER MAPING after change.
Next
From: Dave Page
Date:
Subject: Re: BUG #8288: 9.3.0Beta2 - Windows Installer bug #7738 still open