On Fri, 19 Jul 2024, Sung Hsin Lei via Slony1-general wrote:
When I try that locally into a table without slony I get the error
~~~
create temp table c (a timestamptz);
CREATE TABLE
template1=# insert into c values('Fri July 19 12:48:20.754251 2024 WIB');
ERROR: invalid input syntax for type timestamp with time zone: "Fri July 19
12:48:20.754251 2024 WIB"
~~~
Have you tried running slon with a different timezone?
Maybe
export TZ=UTC
into the environment before starting slon(though I haven't tried this)
Steve
Has anyone experienced a timezone issue with Asia/Jakarta?
I'm getting an "Invalid input syntax for type timestamp with time zone" when
slony inserts into sl_confirm table. Apparently,
it does not like the WIB in "Fri July 19 12:48:20.754251 2024 WIB"
Any way of getting around this without changing the timezone in Postgres?
Thanks.
Sung Hsin
_______________________________________________
Slony1-general mailing list
Slony1-general@lists.slony.info
https://lists.slony.info/cgi-bin/mailman/listinfo/slony1-general