Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000

BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000

From
neil@postgrescompare.com
Date:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMwNwpMb2dnZWQgYnk6ICAg
ICAgICAgIE5laWwgQW5kZXJzb24KRW1haWwgYWRkcmVzczogICAgICBuZWls
QHBvc3RncmVzY29tcGFyZS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjZi
ZXRhNApPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAgRW50ZXJwcmlz
ZSBOICg2NCBiaXQpCkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwNCg0KTXkg
cHJvamVjdCBxdWVyaWVzIG1vc3Qgb2YgdGhlIHN5c3RlbSBjYXRhbG9ncyBh
bmQgaGl0IGFuIGlzc3VlIHdpdGggOS42cmMxCm9uIFdpbmRvd3MgMTAuIA0K
DQpTdGVwcyB0byByZXByb2R1Y2U6DQoxLiBTdGFydCBwc3FsDQoyLiBTRUxF
Q1QgKiBmcm9tIHBnX3RpbWV6b25lX2FiYnJldnM7DQoNCkV4cGVjdGVkOg0K
RGF0YSBmcm9tIHBnX3RpbWV6b25lX2FiYnJldnMgdG8gYmUgcmV0dXJuZWQN
Cg0KQWN0dWFsOg0KRVJST1I6IEYwMDAwOiB0aW1lIHpvbmUgYWJicmV2aWF0
aW9uICJub3ZzdCIgaXMgbm90IHVzZWQgaW4gdGltZSB6b25lCiJBc2lhL05v
dm9zaWJpcnNrIg0KDQpTZXR0aW5nIHZlcmJvc2UgcG9pbnRzIHRvIGxpbmUg
MTc1MCBvZiBkYXRldGltZS5jCmh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jl
cy9wb3N0Z3Jlcy9ibG9iL1JFTDlfNl9SQzEvc3JjL2JhY2tlbmQvdXRpbHMv
YWR0L2RhdGV0aW1lLmMjTDE3NTANCg0KUmVnYXJkcywNCk5laWwNCg0KSGVy
ZSBpcyB0aGUgZnVsbCBleGNlcHRpb24gZGF0YToNCiRleGNlcHRpb24NCntO
cGdzcWwuUG9zdGdyZXNFeGNlcHRpb246IEYwMDAwOiB0aW1lIHpvbmUgYWJi
cmV2aWF0aW9uICJub3ZzdCIgaXMgbm90IHVzZWQKaW4gdGltZSB6b25lICJB
c2lhL05vdm9zaWJpcnNrIg0KICAgYXQgTnBnc3FsLk5wZ3NxbENvbm5lY3Rv
ci5Eb1JlYWRNZXNzYWdlKERhdGFSb3dMb2FkaW5nTW9kZQpkYXRhUm93TG9h
ZGluZ01vZGUsIEJvb2xlYW4gaXNQcmVwZW5kZWRNZXNzYWdlKQ0KICAgYXQg
TnBnc3FsLk5wZ3NxbENvbm5lY3Rvci5SZWFkTWVzc2FnZVdpdGhQcmVwZW5k
ZWQoRGF0YVJvd0xvYWRpbmdNb2RlCmRhdGFSb3dMb2FkaW5nTW9kZSkNCiAg
IGF0IE5wZ3NxbC5OcGdzcWxEYXRhUmVhZGVyLk5leHRSZXN1bHRJbnRlcm5h
bCgpDQogICBhdCBOcGdzcWwuTnBnc3FsRGF0YVJlYWRlci5OZXh0UmVzdWx0
KCkNCiAgIGF0IE5wZ3NxbC5OcGdzcWxDb21tYW5kLkV4ZWN1dGUoQ29tbWFu
ZEJlaGF2aW9yIGJlaGF2aW9yKQ0KICAgYXQgTnBnc3FsLk5wZ3NxbENvbW1h
bmQuRXhlY3V0ZURiRGF0YVJlYWRlckludGVybmFsKENvbW1hbmRCZWhhdmlv
cgpiZWhhdmlvcikNCiAgIGF0IE9iamVjdE1vZGVsLkRhdGFiYXNlTW9kZWxC
dWlsZGVyLlJlYWQoSURiQ29ubmVjdGlvbiBjb25uZWN0aW9uLApBY3Rpb25g
MSBvYmplY3RDcmVhdGVkLCBTdHJpbmcgcXVlcnksIFR5cGUgdHlwZVRvQ3Jl
YXRlKSBpbgpDOlxVc2Vyc1xlbmVpYW5kXGRldlxwb3N0Z3Jlc3FsY29tcGFy
ZVxkb3RuZXRjb3JlXHNyY1xtb2RlbHNcRGF0YWJhc2VNb2RlbEJ1aWxkZXIu
Y3M6bGluZQoxMDINCiAgIGF0IE9iamVjdE1vZGVsLkRhdGFiYXNlTW9kZWxC
dWlsZGVyLkJ1aWxkKElEYkNvbm5lY3Rpb24gZGJDb25uZWN0aW9uKSBpbgpD
OlxVc2Vyc1xlbmVpYW5kXGRldlxwb3N0Z3Jlc3FsY29tcGFyZVxkb3RuZXRj
b3JlXHNyY1xtb2RlbHNcRGF0YWJhc2VNb2RlbEJ1aWxkZXIuY3M6bGluZQo4
Ng0KICAgYXQgSW50ZWdyYXRpb25UZXN0cy5UZXN0RnJhbWV3b3JrLlV0aWxp
dGllcy5HZXREYXRhYmFzZXMoRGF0YWJhc2VTY2hlbWEKc2NoZW1hWCwgRGF0
YWJhc2VTY2hlbWEgc2NoZW1hWSkgaW4KQzpcVXNlcnNcZW5laWFuZFxkZXZc
cG9zdGdyZXNxbGNvbXBhcmVcZG90bmV0Y29yZVx0ZXN0XGludGVncmF0aW9u
XHRlc3RmcmFtZXdvcmtcVXRpbGl0aWVzLmNzOmxpbmUKNjYNCiAgIGF0IElu
dGVncmF0aW9uVGVzdHMuVGVzdEZyYW1ld29yay5VdGlsaXRpZXMuR2V0Q29t
cGFyaXNvbihEYXRhYmFzZVNjaGVtYQpzY2hlbWFYLCBEYXRhYmFzZVNjaGVt
YSBzY2hlbWFZLCBTdHJpbmcgY29tcGFyaXNvbk5hbWUpIGluCkM6XFVzZXJz
XGVuZWlhbmRcZGV2XHBvc3RncmVzcWxjb21wYXJlXGRvdG5ldGNvcmVcdGVz
dFxpbnRlZ3JhdGlvblx0ZXN0ZnJhbWV3b3JrXFV0aWxpdGllcy5jczpsaW5l
CjQwDQogICBhdCBJbnRlZ3JhdGlvblRlc3RzLkNvbXBhcmlzb24uQ29sdW1u
Q29tcGFyaXNvbi5CYXNpY0lkZW50aWNhbFRlc3QoKSBpbgpDOlxVc2Vyc1xl
bmVpYW5kXGRldlxwb3N0Z3Jlc3FsY29tcGFyZVxkb3RuZXRjb3JlXHRlc3Rc
aW50ZWdyYXRpb25cY29tcGFyaXNvblxDb2x1bW5Db21wYXJpc29uLmNzOmxp
bmUKMTR9DQogICAgQmFzZU1lc3NhZ2U6ICJ0aW1lIHpvbmUgYWJicmV2aWF0
aW9uIFwibm92c3RcIiBpcyBub3QgdXNlZCBpbiB0aW1lIHpvbmUKXCJBc2lh
L05vdm9zaWJpcnNrXCIiDQogICAgQ29kZTogIkYwMDAwIg0KICAgIENvbHVt
bk5hbWU6IG51bGwNCiAgICBDb25zdHJhaW50TmFtZTogbnVsbA0KICAgIERh
dGE6IENvdW50ID0gOA0KICAgIERhdGFUeXBlTmFtZTogbnVsbA0KICAgIERl
dGFpbDogbnVsbA0KICAgIEZpbGU6ICJkYXRldGltZS5jIg0KICAgIEhSZXN1
bHQ6IC0yMTQ2MjMzMDg4DQogICAgSGVscExpbms6IG51bGwNCiAgICBIaW50
OiBudWxsDQogICAgSW5uZXJFeGNlcHRpb246IG51bGwNCiAgICBJbnRlcm5h
bFBvc2l0aW9uOiAwDQogICAgSW50ZXJuYWxRdWVyeTogbnVsbA0KICAgIExp
bmU6ICIxNzUwIg0KICAgIE1lc3NhZ2U6ICJGMDAwMDogdGltZSB6b25lIGFi
YnJldmlhdGlvbiBcIm5vdnN0XCIgaXMgbm90IHVzZWQgaW4gdGltZQp6b25l
IFwiQXNpYS9Ob3Zvc2liaXJza1wiIg0KICAgIE1lc3NhZ2VUZXh0OiAidGlt
ZSB6b25lIGFiYnJldmlhdGlvbiBcIm5vdnN0XCIgaXMgbm90IHVzZWQgaW4g
dGltZSB6b25lClwiQXNpYS9Ob3Zvc2liaXJza1wiIg0KICAgIFBvc2l0aW9u
OiAwDQogICAgUm91dGluZTogIkRldGVybWluZVRpbWVab25lQWJicmV2T2Zm
c2V0SW50ZXJuYWwiDQogICAgU2NoZW1hTmFtZTogbnVsbA0KICAgIFNldmVy
aXR5OiAiRVJST1IiDQogICAgU291cmNlOiAiTnBnc3FsIg0KICAgIFNxbFN0
YXRlOiAiRjAwMDAiDQogICAgU3RhY2tUcmFjZTogIiAgIGF0Ck5wZ3NxbC5O
cGdzcWxDb25uZWN0b3IuRG9SZWFkTWVzc2FnZShEYXRhUm93TG9hZGluZ01v
ZGUgZGF0YVJvd0xvYWRpbmdNb2RlLApCb29sZWFuIGlzUHJlcGVuZGVkTWVz
c2FnZSlcclxuICAgYXQKTnBnc3FsLk5wZ3NxbENvbm5lY3Rvci5SZWFkTWVz
c2FnZVdpdGhQcmVwZW5kZWQoRGF0YVJvd0xvYWRpbmdNb2RlCmRhdGFSb3dM
b2FkaW5nTW9kZSlcclxuICAgYXQKTnBnc3FsLk5wZ3NxbERhdGFSZWFkZXIu
TmV4dFJlc3VsdEludGVybmFsKClcclxuICAgYXQKTnBnc3FsLk5wZ3NxbERh
dGFSZWFkZXIuTmV4dFJlc3VsdCgpXHJcbiAgIGF0Ck5wZ3NxbC5OcGdzcWxD
b21tYW5kLkV4ZWN1dGUoQ29tbWFuZEJlaGF2aW9yIGJlaGF2aW9yKVxyXG4g
ICBhdApOcGdzcWwuTnBnc3FsQ29tbWFuZC5FeGVjdXRlRGJEYXRhUmVhZGVy
SW50ZXJuYWwoQ29tbWFuZEJlaGF2aW9yCmJlaGF2aW9yKVxyXG4gICBhdCBP
YmplY3RNb2RlbC5EYXRhYmFzZU1vZGVsQnVpbGRlci5SZWFkKElEYkNvbm5l
Y3Rpb24KY29ubmVjdGlvbiwgQWN0aW9uYDEgb2JqZWN0Q3JlYXRlZCwgU3Ry
aW5nIHF1ZXJ5LCBUeXBlIHR5cGVUb0NyZWF0ZSkgaW4KQzpcXFVzZXJzXFxl
bmVpYW5kXFxkZXZcXHBvc3RncmVzcWxjb21wYXJlXFxkb3RuZXRjb3JlXFxz
cmNcXG1vZGVsc1xcRGF0YWJhc2VNb2RlbEJ1aWxkZXIuY3M6bGluZQoxMDJc
clxuICAgYXQgT2JqZWN0TW9kZWwuRGF0YWJhc2VNb2RlbEJ1aWxkZXIuQnVp
bGQoSURiQ29ubmVjdGlvbgpkYkNvbm5lY3Rpb24pIGluCkM6XFxVc2Vyc1xc
ZW5laWFuZFxcZGV2XFxwb3N0Z3Jlc3FsY29tcGFyZVxcZG90bmV0Y29yZVxc
c3JjXFxtb2RlbHNcXERhdGFiYXNlTW9kZWxCdWlsZGVyLmNzOmxpbmUKODZc
clxuICAgYXQKSW50ZWdyYXRpb25UZXN0cy5UZXN0RnJhbWV3b3JrLlV0aWxp
dGllcy5HZXREYXRhYmFzZXMoRGF0YWJhc2VTY2hlbWEKc2NoZW1hWCwgRGF0
YWJhc2VTY2hlbWEgc2NoZW1hWSkgaW4gQzpcXFVzZXJzXFxlbmVpYW5kXFxk
ZXZcXA0KcG9zdGdyZXNxbGNvbXBhcmVcXGRvdG5ldGNvcmVcXHRlc3RcXGlu
dGVncmF0aW9uXFx0ZXN0ZnJhbWV3b3JrXFxVdGlsaXRpZXMuY3M6bGluZQo2
NlxyXG4gICBhdApJbnRlZ3JhdGlvblRlc3RzLlRlc3RGcmFtZXdvcmsuVXRp
bGl0aWVzLkdldENvbXBhcmlzb24oRGF0YWJhc2VTY2hlbWEKc2NoZW1hWCwg
RGF0YWJhc2VTY2hlbWEgc2NoZW1hWSwgU3RyaW5nIGNvbXBhcmlzb25OYW1l
KSBpbgpDOlxcVXNlcnNcXGVuZWlhbmRcXGRldlxccG9zdGdyZXNxbGNvbXBh
cmVcXGRvdG5ldGNvcmVcXHRlc3RcXGludGVncmF0aW9uXFx0ZXN0ZnJhbWV3
b3JrXFxVdGlsaXRpZXMuY3M6bGluZQo0MFxyXG4gICBhdApJbnRlZ3JhdGlv
blRlc3RzLkNvbXBhcmlzb24uQ29sdW1uQ29tcGFyaXNvbi5CYXNpY0lkZW50
aWNhbFRlc3QoKSBpbgpDOlxcVXNlcnNcXGVuZWlhbmRcXGRldlxccG9zdGdy
ZXNxbGNvbXBhcmVcXGRvdG5ldGNvcmVcXHRlc3RcXGludGVncmF0aW9uXFxj
b21wYXJpc29uXFxDb2x1bW5Db21wYXJpc29uLmNzOmxpbmUKMTQiDQogICAg
U3RhdGVtZW50OiB7U0VMRUNUIGFiYnJldiwgdXRjX29mZnNldCwgaXNfZHN0
IEZST00gcGdfdGltZXpvbmVfYWJicmV2cwp9DQogICAgVGFibGVOYW1lOiBu
dWxsDQogICAgV2hlcmU6IG51bGwNCg0KCgo=

Re: BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000

From
Neil Anderson
Date:
On 2016-09-01 11:15 PM, neil@postgrescompare.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      14307
> Logged by:          Neil Anderson
> Email address:      neil@postgrescompare.com
> PostgreSQL version: 9.6beta4
> Operating system:   Windows 10 Enterprise N (64 bit)
> Description:
>
> Hi,
>
> My project queries most of the system catalogs and hit an issue with 9.6rc1
> on Windows 10.

Further to this the same error appears in 9.5.4 but not in 9.5.3


--
Neil Anderson
neil@postgrescompare.com
http://blog.postgrescompare.com

Re: BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000

From
Tom Lane
Date:
neil@postgrescompare.com writes:
> 2. SELECT * from pg_timezone_abbrevs;
> ERROR: F0000: time zone abbreviation "novst" is not used in time zone
> "Asia/Novosibirsk"

Hm, yeah, IANA changed the data they ship for Asia/Novosibirsk and we
missed the impact it would have on our stuff :-(.  I've started a thread
on what to do about this over in pgsql-hackers:
https://www.postgresql.org/message-id/flat/6189.1472820913%40sss.pgh.pa.us

Thanks for the report!

            regards, tom lane