DB migration failing with "malformed array literal" on PostgreSQL #144

New Issue

raucao · 2023-09-01T10:41:09Z

raucao commented

2023-09-01 10:41:09 +00:00

Caused by:                                                                                                                                                            
ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR:  malformed array literal: "--- []"

LINE 1: ...ken" character varying, "permissions" text[] DEFAULT '--- []

DETAIL:  Array value must start with "{" or dimension information.

```plain Caused by: ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: malformed array literal: "--- []" LINE 1: ...ken" character varying, "permissions" text[] DEFAULT '--- [] DETAIL: Array value must start with "{" or dimension information. ```

raucao added the

bug

label 2023-09-01 10:41:09 +00:00

raucao changed title from ~~DB migration for RS authorizations failing with "malformed array literal"~~ to DB migration failing with "malformed array literal"

2023-09-01 10:41:15 +00:00

raucao changed title from ~~DB migration failing with "malformed array literal"~~ to DB migration failing with "malformed array literal" on PostgreSQL

2023-09-01 10:41:38 +00:00

raucao commented

2023-09-01 10:53:00 +00:00

https://stackoverflow.com/a/43141593

raucao self-assigned this 2023-09-03 11:45:06 +00:00

raucao referenced a pull request that will close this issue

2023-09-03 13:30:02 +00:00

Fix migration failing with PostgreSQL #145

raucao closed this issue

2023-09-03 13:32:36 +00:00

Sign in to join this conversation.