HiOn Mon, Feb 19, 2018 at 7:56 AM, Khushboo Vashi <khushboo.vashi@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" functionsThis causes additional quoting on regular tables. Please see the generated SQL for the index below:
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
-- 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 PageBlog: http://pgsnake.blogspot.comTwitter: @pgsnakeEnterpriseDB UK: http://www.enterprisedb.comThe Enterprise PostgreSQL Company
pgadmin-hackers by date:
Соглашаюсь с условиями обработки персональных данных