invalid input syntax for type timestamp from SQLite to Postgres

[AruMoon]

Followed #1177 suggestion: build from latest sources Still having invalid input syntax for type timestamp error

Tried both versions pgloader version "3.6.3~devel" compiled with SBCL 2.1.1.debian

pgloader version "3.6.a94a0a3" compiled with SBCL 2.1.1.debian

[AruMoon]

https://github.com/dimitri/pgloader/blob/master/src/sources/sqlite/sqlite-cast-rules.lisp#L112 Tried to replace datetime('now','localtime') to datetime('now') and it helped Need to fix

[joshughes]

2022-04-16T15:49:52.984000Z ERROR Database error 22007: invalid input syntax for type timestamp with time zone: "datetime('now')"
QUERY: CREATE TABLE "user"
(
  email                text,
  name                 text,
  createdat            timestamptz default 'datetime(''now'')',
  updatedat            timestamptz default 'datetime(''now'')',
  deletedat            timestamptz,
  password             text default '(uuid_generate_v4())',
  auth_method          text,
  expiration_date      timestamptz,
  required_user        boolean default '0',
  password_reset_token text,
  badge_barcode        text,
  lastlogin            timestamptz,
  id                   text,
  language             text
);
2022-04-16T15:49:53.133000Z FATAL Failed to create the schema, see above.

Similar issue here

2022-04-16T15:49:27.025000Z LOG pgloader version "3.6.3~devel"