pgadmin-org / pgadmin-org/pgadmin4
The index column is not shown in the Properties dialogue if the column name contains double quotes *
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
The index column is not shown in the Properties dialogue if the column name contains double quotes
To Reproduce
Steps to reproduce the behavior:
- create the following database
CREATE DATABASE """"
WITH
OWNER = enterprisedb
ENCODING = 'UTF8'
CONNECTION LIMIT = -1
IS_TEMPLATE = False; - database created
- Click on this newly created database and expand it
- create the following table and index
CREATE TABLE public.""""
(
"""" "char"
);
CREATE INDEX
ON public."""" USING btree
("""" ASC NULLS LAST)
;
5. Tables and index created
6. Expand the index and Right Click and Expand properties
7. Error message Column and Column not empty message is also shown.
Expected behavior
The index column should be displayed in case of special characters.
Error message
If possible, include the full, unedited text of any error messages displayed.
Screenshots
Desktop (please complete the following information):
- OS: [All]
- Version: [7.3]
- Mode: [All]
- Package type: [All]
Additional context
Add any other context about the problem here.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce this in pgAdmin 4 with PostgreSQL using the quoted database, table, and index from the issue. Start at the index Properties dialog and trace how its column name is loaded and displayed; done means the quoted index column appears without the empty-column error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases, frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100