RE: TR: redundant constraint_schema

2018-09-01 Thread Olivier Leprêtre
id #15361 Done, thanks ! -Message d'origine- De : Andreas Kretschmer [mailto:andr...@a-kretschmer.de] Envoyé : samedi 1 septembre 2018 19:01 À : pgsql-general@lists.postgresql.org Objet : Re: TR: redundant constraint_schema Am 01.09.2018 um 18:52 schrieb Adrian Klaver: > On 09

Re: TR: redundant constraint_schema

2018-09-01 Thread Andreas Kretschmer
Am 01.09.2018 um 18:52 schrieb Adrian Klaver: On 09/01/2018 09:47 AM, Olivier Leprêtre wrote: Mine is 9.6 I would submit a bug report here: https://www.postgresql.org/account/login/?next=/account/submitbug/ Olivier, please do that! Regards, Andreas -- 2ndQuadrant - The PostgreSQL Supp

Re: TR: redundant constraint_schema

2018-09-01 Thread Adrian Klaver
:45 À : Andreas Kretschmer; pgsql-general@lists.postgresql.org Objet : Re: TR: redundant constraint_schema On 09/01/2018 09:27 AM, Andreas Kretschmer wrote: Am 01.09.2018 um 17:50 schrieb Olivier Leprêtre: I notice that a new constraint "table1_col2_fkeyxxx" is created each time the previ

RE: TR: redundant constraint_schema

2018-09-01 Thread Olivier Leprêtre
Mine is 9.6 -Message d'origine- De : Adrian Klaver [mailto:adrian.kla...@aklaver.com] Envoyé : samedi 1 septembre 2018 18:45 À : Andreas Kretschmer; pgsql-general@lists.postgresql.org Objet : Re: TR: redundant constraint_schema On 09/01/2018 09:27 AM, Andreas Kretschmer

Re: TR: redundant constraint_schema

2018-09-01 Thread Andreas Kretschmer
Am 01.09.2018 um 18:44 schrieb Adrian Klaver: Forgot to include Postgres version, 10.5. also 9.6 and 11beta1 Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com

Re: TR: redundant constraint_schema

2018-09-01 Thread Adrian Klaver
On 09/01/2018 09:27 AM, Andreas Kretschmer wrote: Am 01.09.2018 um 17:50 schrieb Olivier Leprêtre: I notice that a new constraint "table1_col2_fkeyxxx" is created each time the previous ALTER TABLE ADD COLUMN is called smells like a bug. Regards, Andreas Forgot to include Postgres versio

Re: TR: redundant constraint_schema

2018-09-01 Thread Adrian Klaver
On 09/01/2018 09:27 AM, Andreas Kretschmer wrote: Am 01.09.2018 um 17:50 schrieb Olivier Leprêtre: I notice that a new constraint "table1_col2_fkeyxxx" is created each time the previous ALTER TABLE ADD COLUMN is called smells like a bug. Yeah, a quick test on a database where I have an eve

Re: TR: redundant constraint_schema

2018-09-01 Thread Andreas Kretschmer
Am 01.09.2018 um 17:50 schrieb Olivier Leprêtre: I notice that a new constraint "table1_col2_fkeyxxx" is created each time the previous ALTER TABLE ADD COLUMN is called smells like a bug. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com