Scan array column fail

[hung-voanh]

Hi. I have postgresql table which column is string array type

I checked that all the data are correct.

When I run the models.MarketCategories.Query(), I got this error:

can't scan into dest[4] (col: sub_types): pq: unable to parse array; expected '{' at offset 0"}

Here are the struct that bob gen:

// MarketCategory is an object representing the database table.
type MarketCategory struct {
	...
	SubTypes     pq.StringArray      `db:"sub_types" json:"sub_types"` // this column get failed
	R marketCategoryR `db:"-" json:"-"`
}

[stephenafamo]

Can you share a minimal schema that reproduces this?

[hung-voanh]

Sure. Here is it.

+---------------+-----------------------------+-----------------------------------------------------------------+----------+--------------+-------------+
| Column        | Type                        | Modifiers                                                       | Storage  | Stats target | Description |
|---------------+-----------------------------+-----------------------------------------------------------------+----------+--------------+-------------|
| id            | integer                     |  not null default nextval('market_categories_id_seq'::regclass) | plain    | <null>       | <null>      |
| name          | character varying(255)      |  not null                                                       | extended | <null>       | <null>      |
| description   | text                        |                                                                 | extended | <null>       | <null>      |
| market_id     | integer                     |                                                                 | plain    | <null>       | <null>      |
| sub_types     | character varying[]         |  not null                                                       | extended | <null>       | <null>      |
| created_at    | timestamp without time zone |  default CURRENT_TIMESTAMP                                      | plain    | <null>       | <null>      |
| updated_at    | timestamp without time zone |                                                                 | plain    | <null>       | <null>      |
| deleted_at    | timestamp without time zone |                                                                 | plain    | <null>       | <null>      |
+---------------+-----------------------------+-----------------------------------------------------------------+----------+--------------+-------------+

[stephenafamo]

Please share as an SQL create table statement

[hung-voanh]

CREATE TABLE market_categories (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  market_id INTEGER REFERENCES markets(id),
  sub_types VARCHAR[] NOT NULL,
  created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP WITHOUT TIME ZONE,
  deleted_at TIMESTAMP WITHOUT TIME ZONE
);

[hung-voanh]

Hi @stephenafamo any update from this?
Thank you.

[hung-voanh]

FYI: If I try to replace the generated pq.StringArray field to []string then it work.

[nakhoaprophetx]

thank @hung-voanh

[stephenafamo]

I haven't had time to dig into this yet.

What driver are you using?

[hung-voanh]

I'm using driver: "github.com/jackc/pgx/v5/stdlib"

I add this config to replace the generated pq.StringArray to []string and it works.

replacements:
  - tables: ["market_categories"]
    match:
      name: "sub_types"
    replace: "[]string"