search

electric-sql / pglite

Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno
https://electric-sql.com
Apache License 2.0
4.76k stars 81 forks source link

Attempting to `SET TIME ZONE` throws error #62

Open samwillis opened 3 months ago

samwillis commented 3 months ago

Attempting to SET TIME ZONE 'UTC'; will throw an error:

invalid value for parameter "TimeZone": "UTC"

This is due to missing timezone data in the Emscripten filesystem:

SELECT * FROM pg_timezone_names();
-- could not open directory "/usr/share/zoneinfo": No such file or directory