Comments (3)
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.
from pgtype.
Related Issues (20)
- Known vulnerability in outdated pgx dependency, pgproto3-1.1.0 HOT 2
- Question: JSONBArray EncodeText HOT 2
- lseq type is not transitional decoding HOT 1
- Is it possible to omit undefined values? HOT 1
- invalid field found for struct github.com/jackc/pgtype.Inet's field IPNet: define a valid foreign key for relations or implement the Valuer/Scanner interface HOT 1
- BC Dates cause errors for the pgdate scanner HOT 3
- Json marshaling and unmarshaling of pgtype.inet HOT 2
- panic when scanning null enum to *sql.Scanner HOT 3
- DecodeBinary can't decode NaN HOT 7
- Not Support for nil macaddr HOT 1
- typo in error message
- scanning Daterange fails in v1.14.0
- Register a custom type with sqlx HOT 15
- Numeric type is broken for small negative values HOT 4
- Bug scanning Numeric in v1.14.1 HOT 3
- Release 1.14.3 HOT 1
- Support serialisation of pgtype.Type HOT 1
- comparing uncomparable type pgtype.VarcharArray HOT 3
- Unable to create and use [][]String types in postgres
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgtype.