Jack Christensen
Jack Christensen
There shouldn't be any difference between `text` and `varchar`. I think something else might be going on. 1. The error message references `dest[3]`, but only 3 values are passed into...
> Would it be possible to add a case for []json.RawMessage in .Set? If that is the solution then it should be possible to add it to typed_array_gen.sh and regenerate...
The code that tries to automatically handle unknown types is hard to reason about. The JSON code path is even harder because it automatically calls `json.Marshal` with anything that isn't...
Look in the `pg_type` table. e.g. `select oid, typname from pg_type;`
The original reason was that PG arrays can be multi-dimensional and have arbitrary indexes. e.g. ``` jack@[local]:5432 jack=# select '[3:4][5:7]={{1,2,3},{4,5,6}}'::int4[]; int4 ────────────────────────────── [3:4][5:7]={{1,2,3},{4,5,6}} (1 row) ``` There is no clear...
That would be more convenient but there is one problem. The `Set` method accepts `interface{}` and returns an `error`. This is so it can convert between compatible types such as...
I try to follow the rule that libraries shouldn't panic unless it is an obvious exception like a `MustDoAThing` variant of `DoAThing`. I guess the constructor could be prefixed with...
Composite types will be significantly simpler in pgx v5. See https://github.com/jackc/pgx/blob/v5-dev/pgtype/composite_test.go for some examples of the new style.
There's no special support for it, but you can read it and write it as a `string`.
> Most connection attempts are successful, but occasionally we get errors, making me think that there's some underlying network / database issue causing the problems. That error message does seem...