Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15446: Crash on ALTER TABLE - Mailing list pgsql-bugs

From Dmitry Molotkov
Subject Re: BUG #15446: Crash on ALTER TABLE
Date
Msg-id CADfhRDKYosWqKg8OV8HwG2iMhbPYJxqPVesOM_cdE=ESKxKi4g@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15446: Crash on ALTER TABLE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: BUG #15446: Crash on ALTER TABLE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Tree view
I just checked with that statement and pgadmin and it still crash the db. Its not related to my pc, since i initially encountered it on CI with totally different os and setup, and then reproduced it locally.
https://i.imgur.com/qn1cyOz.png here what happen if i execute that alter query in pgadmin

сб, 27 окт. 2018 г. в 4:11, Alvaro Herrera <alvherre@2ndquadrant.com>:
On 2018-Oct-27, Dmitry Molotkov wrote:

> Here is query that make it crash
>
> BEGIN;
> --
> -- Alter field related_modal_background_opacity on theme
> --
> ALTER TABLE "admin_interface_theme" ALTER COLUMN
> "related_modal_background_opacity" TYPE varchar(5) USING
> "related_modal_background_opacity"::varchar(5);
> COMMIT;

Hmm, that works fine for me :-( Can't debug further right now ...

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15464: I use PostgreSQL
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15446: Crash on ALTER TABLE