I'd want to look into how SQLite handles these also. But I'm thinking I should change to this for all timestamps:
timestamp with time zone
references
The SQL standard requires that writing just timestamp be equivalent to timestamp without time zone, and PostgreSQL honors that behavior. timestamptz is accepted as an abbreviation for timestamp with time zone; this is a PostgreSQL extension.
I'd want to look into how SQLite handles these also. But I'm thinking I should change to this for all timestamps:
references