Results 345 comments of Jack Christensen
trafficstars

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...