Select from sqlite to postgres via virtualpg converts null ints to zeros

22 views
Skip to first unread message

Brent Wood

unread,
Jul 16, 2026, 11:37:59 PM (5 days ago) Jul 16
to SpatiaLite Users
HI,

I'm inserting data to a table in postgres from a table in sqlite via virtualpg.

Where an int column has a null value in Sqlite, it is converted to a zero in the Postgres column.

This does not seem to happen with char/varchar columns (so far).

Is there any (simple) way to change this behaviour? 
Should I file a bug report? 
Reply all
Reply to author
Forward
0 new messages