I use exclusively timestamps with time-zone in PostgreSQL, but I just noticed something slightly worrying: If a client inserts/updates a record with a naïve time-stamp, PostgreSQL falls back to a default time-zone which is either given by an environment variable, localtime or a session-setting.
This might not always be correct.
Is it possible to configure PostgreSQL in a way that it will raise an error if it sees a value without time-zone?
timezone
to a good value, but the client can override it if it wants.