miniflux / v2

Minimalist and opinionated feed reader
https://miniflux.app
Apache License 2.0
6.97k stars 727 forks source link

fix: replace timezone function call with view #2950

Open ansg191 opened 3 days ago

ansg191 commented 3 days ago

The pg_timezone_names view was added in 8.2. It should be equivalent to the function query. (Identical on postgres 9.5 and 17) See: https://pgpedia.info/p/pg_timezone_names.html

This small change allows miniflux to run on postgres-compatible databases like CockroachDB, which don't have this function.

Do you follow the guidelines?