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

[Bug]: Error when trying to alter table to columnar when table is case sensitive #234

Closed
pantonis opened this issue Jan 27, 2024 · 2 comments
Assignees
Labels
bug Something isn't working

Comments

@pantonis
Copy link

What's wrong?

I am trying to alter table to a columnar one and I am getting error that the relation does not exist

SELECT columnar.alter_table_set_access_method("AccountSummary", 'columnar');

and I get the following error:

ERROR:  relation "public.accountsummary" does not exist
LINE 1: SELECT  'public.accountsummary'::regclass::oid

It seems that the extension does not consider double quotes which denotes case sensitivity.
To reproduce it try the below:

CREATE TABLE "AccountSummary"
(
    id INT,
    i1 INT,
    i2 INT8,
    n NUMERIC,
    t TEXT
);

and then:

SELECT columnar.alter_table_set_access_method('"AccountSummary"', 'columnar');
@pantonis pantonis added the bug Something isn't working label Jan 27, 2024
@mkaruza
Copy link
Contributor

mkaruza commented Feb 1, 2024

Should be supported with #237

@mkaruza mkaruza closed this as completed Feb 2, 2024
@pantonis
Copy link
Author

Any estimation on when will this fix will be released?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants