Re: [pgAdmin4][Patch]: RM #3066 - Create script doesn't add quotation marks to column names for the "add index" functions

[Dave Page]

Hi

On Mon, Feb 19, 2018 at 7:56 AM, Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix RM #3066 -  Create script doesn't
> add quotation marks to column names for the "add index" functions
>

This causes additional quoting on regular tables. Please see the generated
SQL for the index below:

-- Table: public."CamelCase"

-- DROP TABLE public."CamelCase";

CREATE TABLE public."CamelCase"
(
    "ID" bigint NOT NULL DEFAULT nextval('"CamelCase_ID_seq"'::regclass),
    "SomeColumn" text COLLATE pg_catalog."default",
    b boolean,
    CONSTRAINT "CamelCase_pkey" PRIMARY KEY ("ID")
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public."CamelCase"
    OWNER to postgres;

-- Index: MixedCase_IDX

-- DROP INDEX public."MixedCase_IDX";

CREATE INDEX "MixedCase_IDX"
    ON public."CamelCase" USING btree
    ("""ID""")
    TABLESPACE pg_default;


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company