Crash in pgmemento.restore_record with an array column.

[pgmemento]

Crash in pgmemento.restore_record with an array column.

[FxKu]

Same question here: Have you tried to restore to relational columns and not JSONB? Looks like with missing type information to_jsonb can not work properly for more complex types.

[foxfriends]

I did try with relational columns and had the same error yes:

testdb=# select * from pgmemento.restore_record(1, 100, 'test2', 'public', 2) as (id INTEGER, values TEXT[], pgmemento_audit_id bigint);
ERROR:  malformed array literal: "ghi"
DETAIL:  Array value must start with "{" or dimension information.
CONTEXT:  PL/pgSQL function restore_record(integer,integer,text,text,bigint,boolean) line 11 at RETURN QUERY

[FxKu]

Hm, too bad. As said, I will only find time next week to take a closer look. I think I'll extract values from the logs with ->> operator, which returns text and then hope Postgres is able to cast it implicitly to the given datatype, e.g. ['ghi'] is extracted, but for arrays {'ghi'} is needed. I guess, it could be fixed with checking for special characters at string's start. Let's see

[FxKu]

@foxfriends fixed it. Thanks for raising it!