Обсуждение: BUG #14160: DROP ACCESS METHOD IF EXISTS isn't implemented
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE2MApMb2dnZWQgYnk6ICAg ICAgICAgIEtvdWhlaSBTdXRvdQpFbWFpbCBhZGRyZXNzOiAgICAgIGtvdUBj bGVhci1jb2RlLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNmJldGExCk9w ZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIEdOVS9MaW51eCBzaWQKRGVzY3Jp cHRpb246ICAgICAgICAKCiJEUk9QIEFDQ0VTUyBNRVRIT0QgSUYgRVhJU1RT IiBhZ2FpbnN0IG5vbmV4aXN0ZW50IGFjY2VzcyBtZXRob2QgcmV0dXJucyBh bgplcnJvcjoNCg0KLS0tLQ0KcG9zdGdyZXM9IyBEUk9QIEFDQ0VTUyBNRVRI T0QgSUYgRVhJU1RTIG5vbmV4aXN0ZW50Ow0KRVJST1I6ICB1bmV4cGVjdGVk IG9iamVjdCB0eXBlICgwKQ0KLS0tLQ0KDQpIZXJlIGlzIGFuIGltcGxlbWVu dGF0aW9uOg0KDQotLS0tDQpGcm9tIGE3YjMyZjNhYjNmZWQzYTUzMzRkN2Nh N2Q4ZTMxZWRjNDc0ZGMyNmUgTW9uIFNlcCAxNyAwMDowMDowMCAyMDAxDQpG cm9tOiBLb3VoZWkgU3V0b3UgPGtvdUBjbGVhci1jb2RlLmNvbT4NCkRhdGU6 IEZyaSwgMjcgTWF5IDIwMTYgMTY6MDM6MTEgKzA5MDANClN1YmplY3Q6IFtQ QVRDSF0gSW1wbGVtZW50IERST1AgQUNDRVNTIE1FVEhPRCBJRiBFWElTVFMg YWdhaW5zdApub25leGlzdGVudA0KIGFjY2VzcyBtZXRob2QNCg0KLS0tDQog c3JjL2JhY2tlbmQvY29tbWFuZHMvZHJvcGNtZHMuYyAgICAgICAgICAgICAg fCA0ICsrKysNCiBzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Ryb3BfaWZf ZXhpc3RzLm91dCB8IDUgKysrKysNCiBzcmMvdGVzdC9yZWdyZXNzL3NxbC9k cm9wX2lmX2V4aXN0cy5zcWwgICAgICB8IDQgKysrKw0KIDMgZmlsZXMgY2hh bmdlZCwgMTMgaW5zZXJ0aW9ucygrKQ0KDQpkaWZmIC0tZ2l0IGEvc3JjL2Jh Y2tlbmQvY29tbWFuZHMvZHJvcGNtZHMuYwpiL3NyYy9iYWNrZW5kL2NvbW1h bmRzL2Ryb3BjbWRzLmMNCmluZGV4IDUyMjAyN2EuLmQ5Zjc4NjEgMTAwNjQ0 DQotLS0gYS9zcmMvYmFja2VuZC9jb21tYW5kcy9kcm9wY21kcy5jDQorKysg Yi9zcmMvYmFja2VuZC9jb21tYW5kcy9kcm9wY21kcy5jDQpAQCAtNDM3LDYg KzQzNywxMCBAQCBkb2VzX25vdF9leGlzdF9za2lwcGluZyhPYmplY3RUeXBl IG9ianR5cGUsIExpc3QKKm9iam5hbWUsIExpc3QgKm9iamFyZ3MpDQogCQkJ CX0NCiAJCQl9DQogCQkJYnJlYWs7DQorCQljYXNlIE9CSkVDVF9BQ0NFU1Nf TUVUSE9EOg0KKwkJCW1zZyA9IGdldHRleHRfbm9vcCgiYWNjZXNzIG1ldGhv ZCBcIiVzXCIgZG9lcyBub3QgZXhpc3QsIHNraXBwaW5nIik7DQorCQkJbmFt ZSA9IE5hbWVMaXN0VG9TdHJpbmcob2JqbmFtZSk7DQorCQkJYnJlYWs7DQog CQlkZWZhdWx0Og0KIAkJCWVsb2coRVJST1IsICJ1bmV4cGVjdGVkIG9iamVj dCB0eXBlICglZCkiLCAoaW50KSBvYmp0eXBlKTsNCiAJCQlicmVhazsNCmRp ZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2Ryb3BfaWZf ZXhpc3RzLm91dApiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZHJvcF9p Zl9leGlzdHMub3V0DQppbmRleCA2OTEwYjYyLi45Y2RhOTZiIDEwMDY0NA0K LS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9kcm9wX2lmX2V4aXN0 cy5vdXQNCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZHJvcF9p Zl9leGlzdHMub3V0DQpAQCAtMjI3LDYgKzIyNywxMSBAQCBEUk9QIE9QRVJB VE9SIEZBTUlMWSB0ZXN0X29wZXJhdG9yX2ZhbWlseSBVU0lORwpub19zdWNo X2FtOw0KIEVSUk9SOiAgYWNjZXNzIG1ldGhvZCAibm9fc3VjaF9hbSIgZG9l cyBub3QgZXhpc3QNCiBEUk9QIE9QRVJBVE9SIEZBTUlMWSBJRiBFWElTVFMg dGVzdF9vcGVyYXRvcl9mYW1pbHkgVVNJTkcgbm9fc3VjaF9hbTsNCiBFUlJP UjogIGFjY2VzcyBtZXRob2QgIm5vX3N1Y2hfYW0iIGRvZXMgbm90IGV4aXN0 DQorLS0gYWNjZXNzIG1ldGhvZA0KK0RST1AgQUNDRVNTIE1FVEhPRCBub19z dWNoX2FtOw0KK0VSUk9SOiAgYWNjZXNzIG1ldGhvZCAibm9fc3VjaF9hbSIg ZG9lcyBub3QgZXhpc3QNCitEUk9QIEFDQ0VTUyBNRVRIT0QgSUYgRVhJU1RT IG5vX3N1Y2hfYW07DQorTk9USUNFOiAgYWNjZXNzIG1ldGhvZCAibm9fc3Vj aF9hbSIgZG9lcyBub3QgZXhpc3QsIHNraXBwaW5nDQogLS0gZHJvcCB0aGUg dGFibGUNCiBEUk9QIFRBQkxFIElGIEVYSVNUUyB0ZXN0X2V4aXN0czsNCiBE Uk9QIFRBQkxFIHRlc3RfZXhpc3RzOw0KZGlmZiAtLWdpdCBhL3NyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL2Ryb3BfaWZfZXhpc3RzLnNxbApiL3NyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL2Ryb3BfaWZfZXhpc3RzLnNxbA0KaW5kZXggMDM1NDdjYy4u NGZmMDQ1MCAxMDA2NDQNCi0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2Ry b3BfaWZfZXhpc3RzLnNxbA0KKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwv ZHJvcF9pZl9leGlzdHMuc3FsDQpAQCAtMjI3LDYgKzIyNywxMCBAQCBEUk9Q IE9QRVJBVE9SIEZBTUlMWSBJRiBFWElTVFMgdGVzdF9vcGVyYXRvcl9mYW1p bHkKVVNJTkcgYnRyZWU7DQogRFJPUCBPUEVSQVRPUiBGQU1JTFkgdGVzdF9v cGVyYXRvcl9mYW1pbHkgVVNJTkcgbm9fc3VjaF9hbTsNCiBEUk9QIE9QRVJB VE9SIEZBTUlMWSBJRiBFWElTVFMgdGVzdF9vcGVyYXRvcl9mYW1pbHkgVVNJ Tkcgbm9fc3VjaF9hbTsNCiANCistLSBhY2Nlc3MgbWV0aG9kDQorRFJPUCBB Q0NFU1MgTUVUSE9EIG5vX3N1Y2hfYW07DQorRFJPUCBBQ0NFU1MgTUVUSE9E IElGIEVYSVNUUyBub19zdWNoX2FtOw0KKw0KIC0tIGRyb3AgdGhlIHRhYmxl DQogDQogRFJPUCBUQUJMRSBJRiBFWElTVFMgdGVzdF9leGlzdHM7DQotLSAN CjIuOC4xDQotLS0tCgo=
On Fri, May 27, 2016 at 4:04 PM, <kou@clear-code.com> wrote: > "DROP ACCESS METHOD IF EXISTS" against nonexistent access method returns an > error: > > ---- > postgres=# DROP ACCESS METHOD IF EXISTS nonexistent; > ERROR: unexpected object type (0) > ---- Good catch. The documents are stating that it is implemented though that's not the case. -- Michael
kou@clear-code.com writes: > "DROP ACCESS METHOD IF EXISTS" against nonexistent access method returns an > error: Pushed, thanks! regards, tom lane