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

Hi

On Mon, Feb 19, 2018 at 7:56 AM, Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)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