Re: pg_dump compatibility level / use create view instead of create table/rule
Alex Williams <[email protected]> Wed, 09 Oct 2019 01:11:42 +0000
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <6lzMiLrcDNmkCesVGxnlur_Yq2CxCuVgKicw-iZ5iZGuEyEJVxDQ5q68S96SnHi4TL_BBcUMvxggU4WseMsPq9w0nQyKUe_Cji1_NBjcLQg=@protonmail.com> |
This is a multi-part message in MIME format. --b1_7fce889d64bb8731949c76554db00aee Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 T25lIHF1aWNrIG5vdGUsIG9uIHRoZSA5LjUuMTgsIHdoaWxlIGl0IGNyZWF0ZWQgYSB0YWJsZSwg aXQgcG9zc2libHkgZGlkbid0IGNvbnZlcnQgaXQgaW50byBhIHZpZXcgKHRoYXQgcGcgYWRtaW4g c2hvd3MgaXQgYXMpIGFzIGl0IHByb2JhYmx5IGRpZG4ndCByZWFjaCB0aGUgZW5kIHRvIGFwcGx5 IHRoZSBydWxlIChJIGtpbGxlZCB0aGUgcmVzdG9yZSBtYW51YWxseSB3aGVuIEkgd2FzIGNoZWNr aW5nIHNwZWNpZmljYWxseSBmb3IgdGhlIHZpZXcgaW4gcXVlc3Rpb24gYW5kIG5vdGljZWQgdGhh dCBpdCBjcmVhdGVkIGEgdGFibGUgaW5zdGVhZCBvZiBhIHZpZXc7IHVubGlrZSA5LjIuOSB3aGlj aCBnZW5lcmF0ZWQgYW4gZXJyb3IuKQoKU2VudCB3aXRoIFtQcm90b25NYWlsXShodHRwczovL3By b3Rvbm1haWwuY29tKSBTZWN1cmUgRW1haWwuCgrigJDigJDigJDigJDigJDigJDigJAgT3JpZ2lu YWwgTWVzc2FnZSDigJDigJDigJDigJDigJDigJDigJAKT24gVHVlc2RheSwgT2N0b2JlciA4LCAy MDE5IDk6MDEgUE0sIEFsZXggV2lsbGlhbXMgPHZhbGVuY2VzaGVsbEBwcm90b25tYWlsLmNvbT4g d3JvdGU6Cgo+IEhpLAo+Cj4gQ2FuIHNvbWVvbmUgbGV0IG1lIGtub3cgd2hlbiB5b3UncmUgZG9p bmcgYSBwZ19kdW1wLCBjYW4geW91IHNwZWNpZnkgbm90IHRvIHVzZSB0aGUgdmlldyBydWxlcyBz byB0aGF0IHRoZSBzdGF0ZW1lbnQgaW4gdGhlIHBnX2R1bXAgZmlsZSB1c2VzIGNyZWF0ZSB2aWV3 IGluc3RlYWQgb2YgY3JlYXRlIHRhYmxlL2NyZWF0ZSBydWxlPyBXZSBhcmUgbm90IHVzaW5nIGFu eXRoaW5nIHNwZWNpZmljIHRvIDkuNSBsaWtlIGpzb25iIGNvbHVtbnMsIHNvIHRoZSBEREwgc2hv dWxkIGJlIGNvbXBhdGlibGUgYmV0d2VlbiB2ZXJzaW9ucyB3aGVuIGNyZWF0aW5nIC8gZGVmaW5p bmcgb2JqZWN0cywgaXQganVzdCB0aGUgd2F5IGl0J3MgY3JlYXRpbmcgdGhlbSB0aGF0IGhhcyBj aGFuZ2VkIHdoaWNoIGlzIGNhdXNpbmcgdXMgYW4gaXNzdWUuCj4KPiBXZSBkdW1wIGZyb20gOS41 LjUgYW5kIHJlc3RvcmUgdG8gb25lIDkuNS4xOCBzZXJ2ZXIgYW5kIHR3byA5LjIgc2VydmVycy4u Li53ZSd2ZSBiZWVuIGRvaW5nIHRoaXMgZm9yIGF3aGlsZSBhbmQgaGFkIG5vIGlzc3VlcyB1bnRp bCByZWNlbnRseSB3aXRoIGNlcnRhaW4gdmlld3MgdGhhdCBhcmUgdHJ5aW5nIHRvIGJlIHJlc3Rv cmVkIHdpdGggcnVsZSB2aWV3cyAoc29tZSB2aWV3cyBpbiB0aGUgcGdfZHVtcCBmaWxlIGFyZSBj cmVhdGVkIHdpdGggY3JlYXRlIHZpZXcgYW5kIHNvbWUgYnkgY3JlYXRlIHRhYmxlIC8gY3JlYXRl IHJ1bGUpIEkndmUgcmVhZCB0aGlzOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzku NS9ydWxlcy12aWV3cy5odG1sIGJ1dCBoYXZlbid0IGZ1bGx5IHVuZGVyc3Rvb2QgaXQgeWV0IGFz IHRvIHdoZW4gaXQgYXBwbGllcyB0aGUgY3JlYXRlIHZpZXcgIHZzIGNyZWF0ZSB0YWJsZS9ydWxl IHN5bnRheCwgYXMgdGhlIHBnX2R1bXAgaGFzIGEgY29tYmluYXRpb24gb2YgYm90aC4KPgo+IE9u IHRoZSA5LjUuMTggc2VydmVyIHdoZXJlIGl0IGhhcyB0aGUgY3JlYXRlIHRhYmxlIHN5bnRheCBm b3IgYSB2aWV3LCBpdCBjcmVhdGVzIGEgdGFibGUgaW5zdGVhZCBvZiBhIHZpZXcuCj4KPiBGb3Ig dGhlIDkuMi45IHNlcnZlcnMsIGl0IGdlbmVyYXRlcyBlcnJvcnM6Cj4KPiBwZ19yZXN0b3JlOiBb YXJjaGl2ZXIgKGRiKV0gRXJyb3IgZnJvbSBUT0MgZW50cnkgMTEyNDA7IDEyNTkgNDI3MDMxODIg VEFCTEUgdl9teV92aWV3IHBvc3RncmVzCj4gTElORSAxOTogLi4uRSBPTkxZIHZfbXlfdmlldyBS RVBMSUNBIElELi4uCj4gICAgIENvbW1hbmQgd2FzOiBDUkVBVEUgVEFCTEUgdl9teV92aWV3KAo+ Cj4gcGdfcmVzdG9yZTogW2FyY2hpdmVyIChkYildIEVycm9yIGZyb20gVE9DIGVudHJ5IDg3NjEz OyAyNjE4IDQyNzAzMTg1IFJVTEUgX1JFVFVSTiBwb3N0Z3Jlcwo+ICAgICBDb21tYW5kIHdhczog Q1JFQVRFIFJVTEUgIl9SRVRVUk4iIEFTCj4KPiBBc2lkZSBmcm9tIGFuIHVwZ3JhZGUgdG8gYWxs IHRoZSBzZXJ2ZXJzLCBpcyB0aGVyZSBhbnl3YXkgaW4gcGdfZHVtcCB0byBzZXQgYSBjb21wYXRp YmlsaXR5IGxldmVsIHdoZW4gZHVtcGluZyB0aGUgZGF0YWJhc2U/IEkgY2hlY2tlZCBoZXJlLCBh bmQgSSBkb24ndCB0aGluayB0aGVyZSBpczogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy85LjUvYXBwLXBnZHVtcC5odG1sCj4KPiBNYW55IHRoYW5rcyBpbiBhZHZhbmNlLgo+Cj4gQWxl eAo+Cj4gT3VyIHNldHVwIGlzIHRoZSBmb2xsb3dpbmc6Cj4gMS4gU291cmNlIFBvc3RncmVzcWwg OS41IHNlcnZlciAocGdfZHVtcCBzb3VyY2UpCj4gUG9zdGdyZVNRTCA5LjUuNSBvbiB4ODZfNjQt cGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykgNC40LjcgMjAxMjAzMTMgKFJlZCBI YXQgNC40LjctMTcpLCA2NC1iaXQKPgo+IDIuIFR3byA5LjIuOSBzZXJ2ZXJzICh3ZSByZXN0b3Jl IHRvKQo+IFBvc3RncmVTUUwgOS4yLjkgb24geDg2XzY0LXJlZGhhdC1saW51eC1nbnUsIGNvbXBp bGVkIGJ5IGdjYyAoR0NDKSA0LjguMiAyMDE0MDEyMCAoUmVkIEhhdCA0LjguMi0xNiksIDY0LWJp dAo+Cj4gMy4gT25lIDkuNSAgKHdlIHJlc3RvcmUgdG8pCj4gUG9zdGdyZVNRTCA5LjUuMTggb24g eDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuNC43IDIwMTIwMzEz Cj4gKFJlZCBIYXQgNC40LjctMjMpLCA2NC1iaXQKPgo+IFNlbnQgd2l0aCBbUHJvdG9uTWFpbF0o aHR0cHM6Ly9wcm90b25tYWlsLmNvbSkgU2VjdXJlIEVtYWlsLg== --b1_7fce889d64bb8731949c76554db00aee Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdj5PbmUgcXVpY2sgbm90ZSwgb24gdGhlIDkuNS4xOCwgd2hpbGUgaXQgY3JlYXRlZCBhIHRh YmxlLCBpdCBwb3NzaWJseSBkaWRuJ3QgY29udmVydCBpdCBpbnRvIGEgdmlldyAodGhhdCBwZyBh ZG1pbiBzaG93cyBpdCBhcykgYXMgaXQgcHJvYmFibHkgZGlkbid0IHJlYWNoIHRoZSBlbmQgdG8g YXBwbHkgdGhlIHJ1bGUgKEkga2lsbGVkIHRoZSByZXN0b3JlIG1hbnVhbGx5IHdoZW4gSSB3YXMg Y2hlY2tpbmcgc3BlY2lmaWNhbGx5IGZvciB0aGUgdmlldyBpbiBxdWVzdGlvbiBhbmQgbm90aWNl ZCB0aGF0IGl0IGNyZWF0ZWQgYSB0YWJsZSBpbnN0ZWFkIG9mIGEgdmlldzsgdW5saWtlIDkuMi45 IHdoaWNoIGdlbmVyYXRlZCBhbiBlcnJvci4pPGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXYg Y2xhc3M9InByb3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrIj48ZGl2IGNsYXNzPSJwcm90b25tYWls X3NpZ25hdHVyZV9ibG9jay11c2VyIHByb3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrLWVtcHR5Ij48 YnI+PC9kaXY+PGRpdiBjbGFzcz0icHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stcHJvdG9uIj5T ZW50IHdpdGggPGEgaHJlZj0iaHR0cHM6Ly9wcm90b25tYWlsLmNvbSIgdGFyZ2V0PSJfYmxhbmsi PlByb3Rvbk1haWw8L2E+IFNlY3VyZSBFbWFpbC48YnI+PC9kaXY+PC9kaXY+PGRpdj48YnI+PC9k aXY+PGRpdj7igJDigJDigJDigJDigJDigJDigJAgT3JpZ2luYWwgTWVzc2FnZSDigJDigJDigJDi gJDigJDigJDigJA8YnI+PC9kaXY+PGRpdj4gT24gVHVlc2RheSwgT2N0b2JlciA4LCAyMDE5IDk6 MDEgUE0sIEFsZXggV2lsbGlhbXMgJmx0O3ZhbGVuY2VzaGVsbEBwcm90b25tYWlsLmNvbSZndDsg d3JvdGU6PGJyPjwvZGl2PjxkaXY+IDxicj48L2Rpdj48YmxvY2txdW90ZSBjbGFzcz0icHJvdG9u bWFpbF9xdW90ZSIgdHlwZT0iY2l0ZSI+PGRpdj5IaSw8YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+ PGRpdj5DYW4gc29tZW9uZSBsZXQgbWUga25vdyB3aGVuIHlvdSdyZSBkb2luZyBhIHBnX2R1bXAs IGNhbiB5b3Ugc3BlY2lmeSBub3QgdG8gdXNlIHRoZSB2aWV3IHJ1bGVzIHNvIHRoYXQgdGhlIHN0 YXRlbWVudCBpbiB0aGUgcGdfZHVtcCBmaWxlIHVzZXMgY3JlYXRlIHZpZXcgaW5zdGVhZCBvZiBj cmVhdGUgdGFibGUvY3JlYXRlIHJ1bGU/IFdlIGFyZSBub3QgdXNpbmcgYW55dGhpbmcgc3BlY2lm aWMgdG8gOS41IGxpa2UganNvbmIgY29sdW1ucywgc28gdGhlIERETCBzaG91bGQgYmUgY29tcGF0 aWJsZSBiZXR3ZWVuIHZlcnNpb25zIHdoZW4gY3JlYXRpbmcgLyBkZWZpbmluZyBvYmplY3RzLCBp dCBqdXN0IHRoZSB3YXkgaXQncyBjcmVhdGluZyB0aGVtIHRoYXQgaGFzIGNoYW5nZWQgd2hpY2gg aXMgY2F1c2luZyB1cyBhbiBpc3N1ZS48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5XZSBk dW1wIGZyb20gOS41LjUgYW5kIHJlc3RvcmUgdG8gb25lIDkuNS4xOCBzZXJ2ZXIgYW5kIHR3byA5 LjIgc2VydmVycy4uLi53ZSd2ZSBiZWVuIGRvaW5nIHRoaXMgZm9yIGF3aGlsZSBhbmQgaGFkIG5v IGlzc3VlcyB1bnRpbCByZWNlbnRseSB3aXRoIGNlcnRhaW4gdmlld3MgdGhhdCBhcmUgdHJ5aW5n IHRvIGJlIHJlc3RvcmVkIHdpdGggcnVsZSB2aWV3cyAoc29tZSB2aWV3cyBpbiB0aGUgcGdfZHVt cCBmaWxlIGFyZSBjcmVhdGVkIHdpdGggY3JlYXRlIHZpZXcgYW5kIHNvbWUgYnkgY3JlYXRlIHRh YmxlIC8gY3JlYXRlIHJ1bGUpIEkndmUgcmVhZCB0aGlzOiA8YSBocmVmPSJodHRwczovL3d3dy5w b3N0Z3Jlc3FsLm9yZy9kb2NzLzkuNS9ydWxlcy12aWV3cy5odG1sIj5odHRwczovL3d3dy5wb3N0 Z3Jlc3FsLm9yZy9kb2NzLzkuNS9ydWxlcy12aWV3cy5odG1sPC9hPiBidXQgaGF2ZW4ndCBmdWxs eSB1bmRlcnN0b29kIGl0IHlldCBhcyB0byB3aGVuIGl0IGFwcGxpZXMgdGhlIGNyZWF0ZSB2aWV3 Jm5ic3A7IHZzIGNyZWF0ZSB0YWJsZS9ydWxlIHN5bnRheCwgYXMgdGhlIHBnX2R1bXAgaGFzIGEg Y29tYmluYXRpb24gb2YgYm90aC48YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5PbiB0aGUg OS41LjE4IHNlcnZlciB3aGVyZSBpdCBoYXMgdGhlIGNyZWF0ZSB0YWJsZSBzeW50YXggZm9yIGEg dmlldywgaXQgY3JlYXRlcyBhIHRhYmxlIGluc3RlYWQgb2YgYSB2aWV3LiA8YnI+PC9kaXY+PGRp dj48YnI+PC9kaXY+PGRpdj5Gb3IgdGhlIDkuMi45IHNlcnZlcnMsIGl0IGdlbmVyYXRlcyBlcnJv cnM6IDxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PnBnX3Jlc3RvcmU6IFthcmNoaXZlciAo ZGIpXSBFcnJvciBmcm9tIFRPQyBlbnRyeSAxMTI0MDsgMTI1OSA0MjcwMzE4MiBUQUJMRSB2X215 X3ZpZXcgcG9zdGdyZXM8YnI+PC9kaXY+PGRpdj5MSU5FIDE5OiAuLi5FIE9OTFkgdl9teV92aWV3 IFJFUExJQ0EgSUQuLi48YnI+PC9kaXY+PGRpdj4mbmJzcDsmbmJzcDsmbmJzcDsgQ29tbWFuZCB3 YXM6IENSRUFURSBUQUJMRSB2X215X3ZpZXcoPGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+ cGdfcmVzdG9yZTogW2FyY2hpdmVyIChkYildIEVycm9yIGZyb20gVE9DIGVudHJ5IDg3NjEzOyAy NjE4IDQyNzAzMTg1IFJVTEUgX1JFVFVSTiBwb3N0Z3Jlczxicj48L2Rpdj48ZGl2PiZuYnNwOyZu YnNwOyZuYnNwOyBDb21tYW5kIHdhczogQ1JFQVRFIFJVTEUgIl9SRVRVUk4iIEFTPGJyPjwvZGl2 PjxkaXY+PGJyPjwvZGl2PjxkaXY+QXNpZGUgZnJvbSBhbiB1cGdyYWRlIHRvIGFsbCB0aGUgc2Vy dmVycywgaXMgdGhlcmUgYW55d2F5IGluIHBnX2R1bXAgdG8gc2V0IGEgY29tcGF0aWJpbGl0eSBs ZXZlbCB3aGVuIGR1bXBpbmcgdGhlIGRhdGFiYXNlPyBJIGNoZWNrZWQgaGVyZSwgYW5kIEkgZG9u J3QgdGhpbmsgdGhlcmUgaXM6IDxhIGhyZWY9Imh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2Rv Y3MvOS41L2FwcC1wZ2R1bXAuaHRtbCI+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy85 LjUvYXBwLXBnZHVtcC5odG1sPC9hPjxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pk1hbnkg dGhhbmtzIGluIGFkdmFuY2UuPGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+QWxleDxicj48 L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pk91ciBzZXR1cCBpcyB0aGUgZm9sbG93aW5nOjxicj48 L2Rpdj48ZGl2PjEuIFNvdXJjZSBQb3N0Z3Jlc3FsIDkuNSBzZXJ2ZXIgKHBnX2R1bXAgc291cmNl KTxicj48L2Rpdj48ZGl2PlBvc3RncmVTUUwgOS41LjUgb24geDg2XzY0LXBjLWxpbnV4LWdudSwg Y29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuNC43IDIwMTIwMzEzIChSZWQgSGF0IDQuNC43LTE3KSwg NjQtYml0PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Mi4gVHdvIDkuMi45IHNlcnZlcnMg KHdlIHJlc3RvcmUgdG8pPGJyPjwvZGl2PjxkaXY+UG9zdGdyZVNRTCA5LjIuOSBvbiB4ODZfNjQt cmVkaGF0LWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDQuOC4yIDIwMTQwMTIwIChS ZWQgSGF0IDQuOC4yLTE2KSwgNjQtYml0PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+My4g T25lIDkuNSZuYnNwOyAod2UgcmVzdG9yZSB0byk8YnI+PC9kaXY+PGRpdj5Qb3N0Z3JlU1FMIDku NS4xOCBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykgNC40Ljcg MjAxMjAzMTM8YnI+PC9kaXY+PGRpdj4oUmVkIEhhdCA0LjQuNy0yMyksIDY0LWJpdDxicj48L2Rp dj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48 L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2IGNsYXNzPSJwcm90b25tYWls X3NpZ25hdHVyZV9ibG9jayI+PGRpdiBjbGFzcz0icHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2st dXNlciBwcm90b25tYWlsX3NpZ25hdHVyZV9ibG9jay1lbXB0eSI+PGJyPjwvZGl2PjxkaXYgY2xh c3M9InByb3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrLXByb3RvbiI+U2VudCB3aXRoIDxhIGhyZWY9 Imh0dHBzOi8vcHJvdG9ubWFpbC5jb20iIHRhcmdldD0iX2JsYW5rIj5Qcm90b25NYWlsPC9hPiBT ZWN1cmUgRW1haWwuPGJyPjwvZGl2PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvYmxvY2txdW90ZT48 ZGl2Pjxicj48L2Rpdj4= --b1_7fce889d64bb8731949c76554db00aee--