Skip to content
New issue

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

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

Already on GitHub? # to your account

DROP TABLE with schema does not work #1071

Open
Denchick opened this issue Mar 10, 2025 · 0 comments
Open

DROP TABLE with schema does not work #1071

Denchick opened this issue Mar 10, 2025 · 0 comments
Labels
bug Something isn't working

Comments

@Denchick
Copy link
Collaborator

Denchick commented Mar 10, 2025

Describe the bug
syntax error on pos 25 when you are trying to drop table in format drop schema_name.table_name

To Reproduce

perforator_db_production=> \dt
                                   List of relations
   Schema   |                           Name                           | Type  |   Owner      
------------+----------------------------------------------------------+-------+------------
 perforator | 8b17b52c-965a-4404-a325-cb8c40af9f12_2025-03-01          | table | perforator
 perforator | 8b17b52c-965a-4404-a325-cb8c40af9f12_2025-03-01_unstable | table | perforator
 perforator | 8b17b52c-965a-4404-a325-cb8c40af9f12_2025-03-11          | table | perforator
 perforator | 8b17b52c-965a-4404-a325-cb8c40af9f12_2025-03-11_unstable | table | perforator
 perforator | 9869494e-aea6-4a56-8d29-7eb4d2d6ce8d_2025-03-01          | table | perforator
 perforator | 9869494e-aea6-4a56-8d29-7eb4d2d6ce8d_2025-03-01_unstable | table | perforator
 perforator | eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01          | table | perforator
 perforator | eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable | table | perforator
 perforator | eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-03-01          | table | perforator
 perforator | eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-03-01_unstable | table | perforator
(10 rows)

perforator_db_production=> DROP TABLE perforator.eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable /* __spqr__engine_v2: true */;
ERROR:  client processing error: error processing query 'DROP TABLE perforator.eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable /* __spqr__engine_v2: true */;': syntax error on pos 25, tx status IDLE
perforator_db_production=> DROP TABLE perforator."eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable" /* __spqr__engine_v2: true */;
ERROR:  client processing error: error processing query 'DROP TABLE perforator."eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable" /* __spqr__engine_v2: true */;': syntax error on pos 25, tx status IDLE
perforator_db_production=> DROP TABLE perforator.'eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable' /* __spqr__engine_v2: true */;
ERROR:  client processing error: error processing query 'DROP TABLE perforator.'eed78c80-dcd0-4556-96fd-0e9cf091c175_2025-02-01_unstable' /* __spqr__engine_v2: true */;': syntax error on pos 25, tx status IDLE

Expected behavior
You are able to drop a table, either with a specified schema or not.

@Denchick Denchick added the bug Something isn't working label Mar 10, 2025
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant