pgadmin-org / pgadmin-org/pgadmin4

The index column is not shown in the Properties dialogue if the column name contains double quotes *

Open
#6,481 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Bug
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:

  1. create the following database
    CREATE DATABASE """"
    WITH
    OWNER = enterprisedb
    ENCODING = 'UTF8'
    CONNECTION LIMIT = -1
    IS_TEMPLATE = False;
  2. database created
  3. Click on this newly created database and expand it
  4. 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
Screen Shot 2023-06-22 at 1 49 51 PM

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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.