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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: [pgAdmin4][Patch]: RM #3066 - Create script doesn't add quotationmarks to column names for the "add index" functions
Дата
Msg-id CA+OCxoyeGRo4r4BVvFBGpFrpLwrwxDFJJw88w116BiY97V6=Yw@mail.gmail.com
обсуждение исходный текст
Ответ на [pgAdmin4][Patch]: RM #3066 - Create script doesn't add quotationmarks to column names for the "add index" functions  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Ответы Re: [pgAdmin4][Patch]: RM #3066 - Create script doesn't add quotationmarks to column names for the "add index" functions
Список pgadmin-hackers
Дерево обсуждения
Hi

On 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" 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

В списке pgadmin-hackers по дате отправления: