Thread: BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.
BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.
From
anup.saund@gmail.com
Date:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM3NApMb2dnZWQgYnk6ICAg ICAgICAgIEFudXAgU2F1bmQKRW1haWwgYWRkcmVzczogICAgICBhbnVwLnNh dW5kQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNi4wCk9wZXJh dGluZyBzeXN0ZW06ICAgV2luZG93cyA3ICg2NGJpdCkKRGVzY3JpcHRpb246 ICAgICAgICAKClNDUkVFTlNIT1QgT0YgT1VUUFVUDQo9PT09PT09PT09PT09 PT09PT09PQ0KaHR0cHM6Ly9kbC5kcm9wYm94dXNlcmNvbnRlbnQuY29tL3Uv MzEyMjk2L291dHB1dC5QTkcNCg0KVGVzdCBTY2VuYXJpbw0KPT09PT09PT09 PT09PQ0KUG9zdGdyZVNRTCAtIDkuNCB3YXMgYWxyZWFkeSBpbnN0YWxsZWQu DQpSdW5uaW5nIHRoZSBmb2xsb3dpbmcgY29tbWFuZCB3b3VsZCBwcm9kdWNl IGFuIG91dHB1dCBhcyBwZXIgdGhlIHNjcmVlbnNob3QKYWJvdmUuDQoNCkNE IGM6XFByb2dyYW0gRmlsZXNcUG9zdGdyZVNRTA0KDQouXDkuNFxiaW5ccHNx bC5leGUgIC1sdFUgcG9zdGdyZXMgLXAgNTQzMyAtaCBsb2NhbGhvc3QgLWQg ZGVsbHN0b3JlMiAtYyAKIlxkdHZzIiINCg0KDQpJc3N1ZQ0KPT09PT0NCg0K UnVubmluZyB0aGUgc2FtZSBjb21tYW5kIGFmdGVyIGluc3RhbGxpbmcgOS42 LjAgd291bGQgZ2l2ZSBhIGxpc3QgYQpkYXRhYmFzZXMsIG5vdCB0YWJsZXMv dmlld3Mvc2VxdWVuY2VzLg0KDQouXDkuNlxiaW5ccHNxbC5leGUgIC1sdFUg cG9zdGdyZXMgLXAgNTQzMyAtaCBsb2NhbGhvc3QgLWQgZGVsbHN0b3JlMiAt YyAKIlxkdHZzIiINCg0KDQpBbHNvIHRlc3RlZCB3aXRoIFBvc3RncmVTUUwg dmVyc2lvbiA5LjUgLSB0aGF0IHZlcnNpb24gZG9lcyBwcm9kdWNlIHRoZSBz YW1lCm91dHB1dCBhcyA5LjQuDQoNClVuZm9ydHVuYXRlbHksIEkgY2Fubm90 IGdldCB0aGUgY29tbWFuZHMgdG8gd29yayB3aXRoIDkuNi4NCg0KSSBoYXZl IHJlYWQgb3ZlciB0aGUgZG9jdW1lbnRhdGlvbiBidXQgdGhhdCBzcGVjaWZp YyBzZWN0aW9uIGlzIHN1Z2dlc3RpbmcKdGhlIHNhbWUgdXNhZ2UgYXMgOS41 LzkuNC4NCg0KQW55IGhlbHAgd291bGQgYmUgZ3JlYXRseSBhcHByZWNpYXRl ZC4KCg==
Re: BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.
From
Tom Lane
Date:
anup.saund@gmail.com writes:
> Running the same command after installing 9.6.0 would give a list a
> databases, not tables/views/sequences.
> .\9.6\bin\psql.exe -ltU postgres -p 5433 -h localhost -d dellstore2 -c
> "\dtvs""
I don't think this is a bug. -l is documented as "list available
databases, then exit". It's not specified whether that takes preference
over -c or not. The changes in 9.6 to make -c act more like -f evidently
caused it to not take precedence over -l anymore, and that seems fine
from here.
regards, tom lane