Invalid Postgres Insert Syntax for Slices of String Pointers

[pc-bob]

I have a struct defined like this:

type Location struct {
	ID string `bun:"type:uuid,pk"`

	MyStrings []string `bun:"type:text[],notnull"`

	MyOptionalStrings []*string `bun:"type:text[]"`

}

The postgres statement generated when trying to insert a value for this model does not correctly quote the string values within the array:

INSERT INTO "locations" AS "location" ("id", "my_strings", "my_optional_strings") VALUES ('C99C8B07-B153-4C1C-8CD9-907FC06FD46D', '{"foo","bar"}', '{'baz'}')

This results in an error from postgres:

*pq.Error: pq: syntax error at or near "baz"

The non-nullable string slice works correctly, but the slice of string pointers generates '{'baz'}' when it should generate {"baz"}' to be valid.

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.