NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit312d517

committed

Suppress leap-second-aware timezones in the output of pg_tzenumerate_next,

and thereby in the pg_timezone_names view. Although we allow such zonesto be used in certain limited contexts like AT TIME ZONE, we don't allowthem in SET TIME ZONE, and bug #4528 shows that they're more likely toconfuse users than do anything useful. So hide 'em. (Note that we don'teven generate these zones when installing our own timezone database.But they are likely to be present when using a system-provided database.)

1 parent10e3acb commit312d517Copy full SHA for 312d517

File tree

1 file changed

-1

lines changed

src/timezone
- pgtz.c

1 file changed

-1

lines changed

`‎src/timezone/pgtz.c`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@`
`6`	`6`	`* Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group`
`7`	`7`	`*`
`8`	`8`	`* IDENTIFICATION`
`9`		`- * $PostgreSQL: pgsql/src/timezone/pgtz.c,v 1.60 2008/07/01 03:40:55 tgl Exp $`
	`9`	`+ * $PostgreSQL: pgsql/src/timezone/pgtz.c,v 1.61 2008/11/13 20:49:38 tgl Exp $`
`10`	`10`	`*`
`11`	`11`	`*-------------------------------------------------------------------------`
`12`	`12`	`*/`
`@@ -1499,6 +1499,12 @@ pg_tzenumerate_next(pg_tzenum *dir)`
`1499`	`1499`	`continue;`
`1500`	`1500`	`}`
`1501`	`1501`
	`1502`	`+if (!tz_acceptable(&dir->tz))`
	`1503`	`+{`
	`1504`	`+/* Ignore leap-second zones */`
	`1505`	`+continue;`
	`1506`	`+}`
	`1507`	`+`
`1502`	`1508`	`/* Timezone loaded OK. */`
`1503`	`1509`	`return&dir->tz;`
`1504`	`1510`	`}`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit312d517

File tree

1 file changed

1 file changed

`‎src/timezone/pgtz.c`

0 commit comments