Converting PostgreSQL type timestamp with time zone to base type unsuccessful

[vdinh1]

Hi, I am doing some testing with db-sync and I have found the issue below with initiating db-sync from postgresql.

What is the issue: Error creating a gpkg from postgresql layers

How to replicate: I have a table with a date field defined as follow : survey_date timestamp with time zone Eg.

Create` table survey (
   id text,
   survey_name text,
   survey_date timestamp with time zone
);

Error:

The base schema and the output GPKG do not exist yet, going to initialize them ...
survey_v01  | Warn: Converting PostgreSQL type timestamp with time zone to base type unsuccessful, using text.
survey_v01  | Warn: Converting PostgreSQL type timestamp with time zone to base type unsuccessful, using text.
survey_v01  | Warn: Converting PostgreSQL type timestamp with time zone to base type unsuccessful, using text.
survey_v01  | Warn: Converting PostgreSQL type timestamp with time zone to base type unsuccessful, using text.
survey_v01  | Warn: Converting PostgreSQL type timestamp with time zone to base type unsuccessful, using text.
survey_v01  | Warn: Converting PostgreSQL type timestamp with time zone to base type unsuccessful, using text.
survey_v01  | Error: copy failed!
survey_v01  | GEODIFF: Error: unknown value type: timestamp with time zone

[wonder-sk]

Thanks for the report. As a temporary workaround, you could use timestamp without time zone column type which should work fine...