Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

importccl: cannot load array data with IMPORT PGDUMP #29043

Closed
rytaft opened this issue Aug 24, 2018 · 0 comments · Fixed by #58244
Closed

importccl: cannot load array data with IMPORT PGDUMP #29043

rytaft opened this issue Aug 24, 2018 · 0 comments · Fixed by #58244
Assignees
Labels
A-disaster-recovery C-investigation Further steps needed to qualify. C-label will change. O-qa T-disaster-recovery

Comments

@rytaft
Copy link
Collaborator

rytaft commented Aug 24, 2018

While doing QA for , I tried to load a table with some array data:

CREATE TABLE public.t1 (
    x integer[],
    y integer[]
);

The table was created successfully, but there was an error when trying to load array data:
pq: nodelocal:///single.sql: insert row: value type string doesn't match type ARRAY of column "x"

Array data in Postgres is wrapped in quotation marks like this: '{1}', '{{2,3},{4,6}}'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-disaster-recovery C-investigation Further steps needed to qualify. C-label will change. O-qa T-disaster-recovery
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants