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