Re: dealing with lock

Thank you Thomas Regards Thomas Le sam. 7 avr. 2018 à 08:01, Thomas Kellerer a écrit : > Adrian Klaver schrieb am 07.04.2018 um 00:02: > >> Is there a way to identify the list of statements that have to rewrite > the table. > > > >

Re: dealing with lock

Thank you Laurenz! Regards Thomas Le sam. 7 avr. 2018 à 00:02, Adrian Klaver a écrit : > On 04/06/2018 12:09 PM, Thomas Poty wrote: > > Thank you Laurenz ! > > > > > > We will certainly have to change our release management. > > > > Is there a way to identify the

Re: dealing with lock

Adrian Klaver schrieb am 07.04.2018 um 00:02: Is there a way to identify the list of statements that have to rewrite the table. https://www.postgresql.org/docs/10/static/sql-altertable.html Notes "Adding a column with a DEFAULT clause or changing the type of an existing column will require

Re: dealing with lock

On 04/06/2018 12:09 PM, Thomas Poty wrote: Thank you Laurenz ! We will certainly have to change our release management. Is there a way to identify the list of statements that have to rewrite the table. https://www.postgresql.org/docs/10/static/sql-altertable.html Notes "Adding a column

Re: dealing with lock

Thank you Laurenz ! We will certainly have to change our release management. Is there a way to identify the list of statements that have to rewrite the table. If I am right, at least these statements need to do this : - create a unique index - add a column with a default value Regards,