The "time with time zone" data type doesn't seem to be supported. about pgtype HOT 3 CLOSED

This package is only receiving bug fixes. In pgx v5 the pgtype library is part of the main repo. But regardless, timestamp with time zone is unlikely to be supported. See jackc/pgx#1940 for previous discussion.

from pgtype.

All right, no problem, after reading a few related bugs and the PostgreSQL documentation it's clear the use of this data type is not recommended, and there are good reasons for that. So it's actually a good thing I had to switch to "time without time zone", and I'm fine with this data type not being supported.

In fact I remember reading about this data type not being recommended a few years ago. But when working on a new feature recently, I missed that part in the PostgreSQL documentation, even though I was specifically looking for that language discouraging its use, so I assumed it is OK to use it. In retrospect, after reading more about how that data type works, it was clearly NOT OK. Daylight savings would have caused a huge mess if I kept using it.

However, I think that the documentation for pgtype.Time should make it clear that the "time with time zone" datatype is not not supported, and that its usage is not recommended by PostgreSQL. Even the pgx v5 documentation doesn't mention that.

from pgtype.

However, I think that the documentation for pgtype.Time should make it clear that the "time with time zone" datatype is not not supported, and that its usage is not recommended by PostgreSQL. Even the pgx v5 documentation doesn't mention that.

Fair enough.

jackc/pgx@a68e14f

from pgtype.