pgsql: Make rewriter prevent auto-updates on views with conditional INS
Dean Rasheed <[email protected]> Tue, 14 Jan 2020 09:58:06 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.cvs |
|---|---|
| Message-ID | <[email protected]> |
--===============0467754101766054437== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 TWFrZSByZXdyaXRlciBwcmV2ZW50IGF1dG8tdXBkYXRlcyBvbiB2aWV3cyB3aXRoIGNvbmRpdGlv bmFsIElOU1RFQUQgcnVsZXMuCgpBIHZpZXcgd2l0aCBjb25kaXRpb25hbCBJTlNURUFEIHJ1bGVz IGFuZCBubyB1bmNvbmRpdGlvbmFsIElOU1RFQUQKcnVsZXMgb3IgSU5TVEVBRCBPRiB0cmlnZ2Vy cyBpcyBub3QgYXV0by11cGRhdGFibGUuIFByZXZpb3VzbHkgd2UKcmVsaWVkIG9uIGEgY2hlY2sg aW4gdGhlIGV4ZWN1dG9yIHRvIGNhdGNoIHRoaXMsIGJ1dCB0aGF0J3MKcHJvYmxlbWF0aWMgc2lu Y2UgdGhlIHBsYW5uZXIgbWF5IGZhaWwgdG8gcHJvcGVybHkgaGFuZGxlIHN1Y2ggYSBxdWVyeQph bmQgdGh1cyByZXR1cm4gYSBwYXJ0aWN1bGFybHkgdW5oZWxwZnVsIGVycm9yIHRvIHRoZSB1c2Vy LCBiZWZvcmUKcmVhY2hpbmcgdGhlIGV4ZWN1dG9yIGNoZWNrLgoKSW5zdGVhZCwgdHJhcCB0aGlz IGluIHRoZSByZXdyaXRlciBhbmQgcmVwb3J0IHRoZSBjb3JyZWN0IGVycm9yIHRoZXJlLgpEb2lu ZyBzbyBhbHNvIGFsbG93cyB1cyB0byBpbmNsdWRlIG1vcmUgdXNlZnVsIGVycm9yIGRldGFpbCB0 aGFuIHRoZQpleGVjdXRvciBjaGVjayBjYW4gcHJvdmlkZS4gVGhpcyBkb2Vzbid0IGNoYW5nZSB0 aGUgZXhpc3RpbmcgYmVoYXZpb3VyCm9mIHVwZGF0YWJsZSB2aWV3czsgaXQgbWVyZWx5IGVuc3Vy ZXMgdGhhdCB1c2VmdWwgZXJyb3IgbWVzc2FnZXMgYXJlCnJlcG9ydGVkIHdoZW4gYSB2aWV3IGlz bid0IHVwZGF0YWJsZS4KClBlciByZXBvcnQgZnJvbSBQZW5nemhvdSBUYW5nLCB0aG91Z2ggbm90 IGFkb3B0aW5nIHRoYXQgc3VnZ2VzdGVkIGZpeC4KQmFjay1wYXRjaCB0byBhbGwgc3VwcG9ydGVk IGJyYW5jaGVzLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUc0cmVBUW4rNHhC NnhISnFXZHRFMHZlX1dxSmtkeUNWNFA9dHJZcjRLbjhfM19QRUFAbWFpbC5nbWFpbC5jb20KCkJy YW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNx bC5vcmcvcGcvY29tbWl0ZGlmZi9kNzUxYmE1MjM1NDZkZjJiMjcwOWMxZmZkNGQxMmQ2YTI1ZTI1 YmY2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9l eGVjTWFpbi5jICAgICAgICAgICAgICAgfCAgOCArKy0tCnNyYy9iYWNrZW5kL3Jld3JpdGUvcmV3 cml0ZUhhbmRsZXIuYyAgICAgICAgICB8IDYwICsrKysrKysrKysrKysrKysrKysrKysrKy0tLQpz cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3VwZGF0YWJsZV92aWV3cy5vdXQgfCAyMSArKysrKysr KysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3VwZGF0YWJsZV92aWV3cy5zcWwgICAgICB8IDE0ICsr KysrKysKNCBmaWxlcyBjaGFuZ2VkLCA5NCBpbnNlcnRpb25zKCspLCA5IGRlbGV0aW9ucygtKQoK --===============0467754101766054437==--