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

import: pgdump fails on import with partial index #56366

Closed
dbist opened this issue Nov 6, 2020 · 2 comments
Closed

import: pgdump fails on import with partial index #56366

dbist opened this issue Nov 6, 2020 · 2 comments
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Comments

@dbist
Copy link
Contributor

dbist commented Nov 6, 2020

CREATE TABLE public.test (
    a int PRIMARY KEY,
    b int,
    INDEX b_idx  (b) WHERE b > 5
);
IMPORT PGDUMP 'http://host.docker.internal:8000/test.dump'  WITH max_row_size = '9MB', skip_foreign_keys;
ERROR: unimplemented: cannot import into table with partial indexes                  
SQLSTATE: 0A000                                                                       
HINT: You have attempted to use a feature that is not yet implemented.              
See: https://go.crdb.dev/issue-v/50225/v20.2

Environment:

  • CockroachDB version 20.2.0.rc.4
  • Server OS: docker
  • Client app: cockroach sql

Additional context
What was the impact?

Add any other context about the problem here.

@blathers-crl
Copy link

blathers-crl bot commented Nov 6, 2020

Hi @dbist, I've guessed the C-ategory of your issue and suitably labeled it. Please re-label if inaccurate.

While you're here, please consider adding an A- label to help keep our repository tidy.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

@blathers-crl blathers-crl bot added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Nov 6, 2020
@adityamaru
Copy link
Contributor

Closing as this is already on our radar at #50225.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
None yet
Development

No branches or pull requests

2 participants