Postgres Pro
Downloads
Home   >   mailing lists

BUG #14322: Possible inconsistent behavior with timestamp_to_str() - Mailing list pgsql-bugs

From keith@keithf4.com
Subject BUG #14322: Possible inconsistent behavior with timestamp_to_str()
Date
Msg-id 20160909235448.20021.79001@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14322: Possible inconsistent behavior with timestamp_to_str()  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMyMgpMb2dnZWQgYnk6ICAg
ICAgICAgIEtlaXRoIEZpc2tlCkVtYWlsIGFkZHJlc3M6ICAgICAga2VpdGhA
a2VpdGhmNC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuNApPcGVyYXRp
bmcgc3lzdGVtOiAgIFVidW50dSAxNi4wNApEZXNjcmlwdGlvbjogICAgICAg
IAoKSXQgc2VlbXMgd2hlbiBJIGNhbGwgdGltZXN0YW1wX3RvX3N0cigpIG9u
IGEgbm9uLW51bGwgdmFsdWUgdGhlbiBjYWxsIGl0IG9uCmEgbnVsbCB2YWx1
ZSBpbiB0aGUgc2FtZSBzdGF0ZW1lbnQsIGl0IHJldHVybnMgdGhlIHByZXZp
b3VzIG5vbi1udWxsIHZhbHVlLgpJJ3ZlIGluY2x1ZGVkIHRoZSBjb2RlIGFu
ZCBkZWJ1ZyBsaW5lcyBmcm9tIHdoZXJlIEkgZW5jb3VudGVyZWQgdGhpcyB3
aGVuCnRlc3RpbmcgbXkgYXBwLg0KDQpJIHVzZSBTUEkgdG8gcmV0cmlldmUg
dGhlIHZhbHVlczoNCg0KYXBwZW5kU3RyaW5nSW5mbygmYnVmLCAiU0VMRUNU
IHN1Yl9taW46OnRpbWVzdGFtcHR6LCBzdWJfbWF4Ojp0aW1lc3RhbXB0egpG
Uk9NICVzLmNoZWNrX3N1YnBhcnRpdGlvbl9saW1pdHMoJyVzLiVzJywgJ3Rp
bWUnKSIsIHBhcnRtYW5fc2NoZW1hLApwYXJlbnRfc2NoZW1hbmFtZSwgcGFy
ZW50X3RhYmxlbmFtZSk7DQpyZXQgPSBTUElfZXhlY3V0ZShidWYuZGF0YSwg
dHJ1ZSwgMSk7DQpzdWJfdGltZXN0YW1wX21pbiA9IERhdHVtR2V0VGltZXN0
YW1wVHooU1BJX2dldGJpbnZhbChTUElfdHVwdGFibGUtPnZhbHNbMF0sClNQ
SV90dXB0YWJsZS0+dHVwZGVzYywgMSwgJnN1Yl90aW1lc3RhbXBfbWluX2lz
bnVsbCkpOyANCnN1Yl90aW1lc3RhbXBfbWF4ID0gRGF0dW1HZXRUaW1lc3Rh
bXBUeihTUElfZ2V0YmludmFsKFNQSV90dXB0YWJsZS0+dmFsc1swXSwKU1BJ
X3R1cHRhYmxlLT50dXBkZXNjLCAyLCAmc3ViX3RpbWVzdGFtcF9tYXhfaXNu
dWxsKSk7IA0KDQpRdWVyeWluZyB0aGUgdGFibGUgbm9ybWFsbHksIGNhbiBz
ZWUgaXQgcmV0dXJucyBudWxsczoNCg0Ka2VpdGhAa2VpdGg9IyBzZWxlY3Qg
KiBmcm9tCnBhcnRtYW4uY2hlY2tfc3VicGFydGl0aW9uX2xpbWl0cygncGFy
dG1hbl90ZXN0LnRpbWVfdGFwdGVzdF90YWJsZScsCid0aW1lJyk7DQogc3Vi
X21pbiB8IHN1Yl9tYXggDQotLS0tLS0tLS0rLS0tLS0tLS0tDQogwqtOVUxM
wrsgIHwgwqtOVUxMwrsNCigxIHJvdykNCg0KDQplbG9nKERFQlVHMSwgInN1
Yl90aW1lc3RhbXBfbWluOiAlcywgc3ViX3RpbWVzdGFtcF9taW5faXNudWxs
OiAlZCwKc3ViX3RpbWVzdGFtcF9tYXg6ICVsZCwgc3ViX3RpbWVzdGFtcF9t
YXhfaXNudWxsOiAlZCINCiAgICAgICAgLCB0aW1lc3RhbXB0el90b19zdHIo
c3ViX3RpbWVzdGFtcF9taW4pLCBzdWJfdGltZXN0YW1wX21pbl9pc251bGws
CnN1Yl90aW1lc3RhbXBfbWF4LCBzdWJfdGltZXN0YW1wX21heF9pc251bGwp
Ow0KZWxvZyhERUJVRzEsICJydW5fbWFpbnQgYmVmb3JlIGxvb3A6IGN1cnJl
bnRfcGFydGl0aW9uX3RpbWVzdGFtcDogJXMsCnByZW1hZGVfY291bnQ6ICVk
LCBzdWJfdGltZXN0YW1wX21pbjogJXMsIHN1Yl90aW1lc3RhbXBfbWF4OiAl
cyINCiAgICAgICAgLCB0aW1lc3RhbXB0el90b19zdHIoY3VycmVudF9wYXJ0
aXRpb25fdGltZXN0YW1wKSwgcHJlbWFkZV9jb3VudCwKdGltZXN0YW1wdHpf
dG9fc3RyKHN1Yl90aW1lc3RhbXBfbWluKSwKdGltZXN0YW1wdHpfdG9fc3Ry
KHN1Yl90aW1lc3RhbXBfbWF4KSk7DQplbG9nKERFQlVHMSwgInJ1bl9tYWlu
dCBiZWZvcmUgbG9vcDI6IHByZW1hZGVfY291bnQ6ICVkLCBzdWJfdGltZXN0
YW1wX21pbjoKJXMsIHN1Yl90aW1lc3RhbXBfbWF4OiAlcyINCiAgICAgICAg
LCBwcmVtYWRlX2NvdW50LCB0aW1lc3RhbXB0el90b19zdHIoc3ViX3RpbWVz
dGFtcF9taW4pLAp0aW1lc3RhbXB0el90b19zdHIoc3ViX3RpbWVzdGFtcF9t
YXgpKTsNCg0KICANCkNhbiBzZWUgdGhlIGluaXRpYWwgZGVidWcgbGluZSwg
dGhpbmdzIGFyZSBub3JtYWwuIE5leHQgbGluZQpjdXJyZW50X3BhcnRpdGlv
bl90aW1lc3RhbXAgaXMgcmV0dXJuZWQgYWxvbmcgd2l0aCB0aGUgc3ViIHZh
bHVlcyB3aGljaCBhcmUKdGhlbiBlcXVhbCB0byBjdXJyZW50X3BhcnRpdGlv
bl90aW1lc3RhbXAuIFJlbW92aW5nCmN1cnJlbnRfcGFydGl0aW9uX3RpbWVz
dGFtcCBmcm9tIHRoZSBzYW1lIHN0YXRlbWVudCBpbiB0aGUgZm9sbG93aW5n
IGxpbmUKdGhpbmdzIHJldHVybiBhcyBleHBlY3RlZC4NCg0KDQoyMDE2LTA5
LTA5IDE3OjM4OjE1IEVEVCBbXSBbOTgyOF06IFsyOS0xXSB1c2VyPSxkYj0s
ZT0wMDAwMCBERUJVRzogCnN1Yl90aW1lc3RhbXBfbWluOiAxOTk5LTEyLTMx
IDE5OjAwOjAwLTA1LCBzdWJfdGltZXN0YW1wX21pbl9pc251bGw6IDEsCnN1
Yl90aW1lc3RhbXBfbWF4OiAwLCBzdWJfdGltZXN0YW1wX21heF9pc251bGw6
IDENCjIwMTYtMDktMDkgMTc6Mzg6MTUgRURUIFtdIFs5ODI4XTogWzMwLTFd
IHVzZXI9LGRiPSxlPTAwMDAwIERFQlVHOiAKcnVuX21haW50IGJlZm9yZSBs
b29wOiBjdXJyZW50X3BhcnRpdGlvbl90aW1lc3RhbXA6IDIwMTYtMDktMTEg
MDA6MDA6MDAtMDQsCnByZW1hZGVfY291bnQ6IDAsIHN1Yl90aW1lc3RhbXBf
bWluOiAyMDE2LTA5LTExIDAwOjAwOjAwLTA0LApzdWJfdGltZXN0YW1wX21h
eDogMjAxNi0wOS0xMSAwMDowMDowMC0wNA0KMjAxNi0wOS0wOSAxNzozODox
NSBFRFQgW10gWzk4MjhdOiBbMzEtMV0gdXNlcj0sZGI9LGU9MDAwMDAgREVC
VUc6IApydW5fbWFpbnQgYmVmb3JlIGxvb3AyOiBwcmVtYWRlX2NvdW50OiAw
LCBzdWJfdGltZXN0YW1wX21pbjogMTk5OS0xMi0zMQoxOTowMDowMC0wNSwg
c3ViX3RpbWVzdGFtcF9tYXg6IDE5OTktMTItMzEgMTk6MDA6MDAtMDUNCg0K
SSBrbm93IEkgc2hvdWxkIGFsd2F5cyBjaGVjayBmb3IgYSBudWxsIHJldHVy
biBmcm9tIFNQSSBiZWZvcmUgb3BlcmF0aW5nIG9uCmEgdmFsdWUsIGFuZCBJ
IGRvIGJlZm9yZSBJIGFjdHVhbGx5IHVzZSB0aG9zZSB2YWx1ZXMuIEJ1dCBJ
IGhhZCB0aGVtIGluIG15CmRlYnVnIGxpbmVzIHdoZXJlIGNoZWNraW5nIGZv
ciB3aGV0aGVyIHRoZXkncmUgbnVsbCBiZWZvcmUgb3V0cHV0dGluZyB0bwpk
ZWJ1ZyBkaWRuJ3Qgc2VlbSB0byBtYXR0ZXIgYW5kIGl0IHdhcyByZWFsbHkg
Y29uZnVzaW5nIG1lIHdoeSB0aGUgdmFsdWVzCndlcmUgcmV0dXJuaW5nIHJl
Y2VudCB0aW1lc3RhbXAgdmFsdWVzIHdoZW4gSSB3YXMgcHJldHR5IHN1cmUg
dGhleSB3ZXJlCm51bGwuIE5vdCBzdXJlIGlmIHRoaXMgY2FuIGp1c3QgYmUg
Y2hhbGtlZCB1cCB0byB1bmRlZmluZWQgYmVoYXZpb3Igd2hlbgpkZWFsaW5n
IHdpdGggbnVsbHMgb3IgaXQncyBhbiBhY3R1YWwgcHJvYmxlbSwgc28gZmln
dXJlZCBJJ2QgcmVwb3J0IGl0LgoK

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14321: pg_basebackup --xlog-method=stream fails
Next
From: Andres Freund
Date:
Subject: Re: BUG #14322: Possible inconsistent behavior with timestamp_to_str()