Re: [GENERAL] Column rename in an extension update script

2017-05-03 Thread Philippe BEAUDOIN
Le 03/05/2017 à 19:29, Tom Lane a écrit : Adrian Klaver writes: On 04/30/2017 11:54 PM, Philippe BEAUDOIN wrote: Just after the ALTER TABLE statement, I want to access this table. But at this time, the altered column is not visible with its new name. From the error it looks to me like the s

Re: [GENERAL] Column rename in an extension update script

2017-05-03 Thread Tom Lane
Adrian Klaver writes: > On 04/30/2017 11:54 PM, Philippe BEAUDOIN wrote: >> Just after the ALTER TABLE statement, I want to access this table. But >> at this time, the altered column is not visible with its new name. > From the error it looks to me like the statements are each run in a > separa

Re: [GENERAL] Column rename in an extension update script

2017-05-03 Thread Adrian Klaver
On 04/30/2017 11:54 PM, Philippe BEAUDOIN wrote: Hi all, I am coding an update script for an extension. And I am in trouble when trying to rename a column of an existing table. Just after the ALTER TABLE statement, I want to access this table. But at this time, the altered column is not visible

[GENERAL] Column rename in an extension update script

2017-05-02 Thread Philippe BEAUDOIN
Hi all, I am coding an update script for an extension. And I am in trouble when trying to rename a column of an existing table. Just after the ALTER TABLE statement, I want to access this table. But at this time, the altered column is not visible with its new name. I wrote a simple test cas