dump |grep 'CREATE SEQUENCE')
---
CREATE SEQUENCE t1_c1_seq
CREATE SEQUENCE t2_c1_seq
CREATE SEQUENCE t3_c1_seq
=> as expected, with latest minor versions of postgres 9.1 to 9.5, the
sequences associated to the t1.c1 and t1.c3 columns are not dumped,
while the sequence associated to t2.c1 is dumped.
=> with 9.6beta3 (as with beta2), the 3 sequences are dumped.
cleanup
---
DROP EXTENSION
DROP SCHEMA
I will be off during the 2 coming weeks. So I will only see any reply to
this thread ... soon.
Best regards.
Philippe Beaudoin.
ot;
does not exist", while the ALTER TABLE statement doesn't return any error,
- the same statements in a simple psql script works fine,
- I reproduce this with all supported postgres versions.
As a workaround, I perform the UPDATE statement before the ALTER TABLE
operation, using of course the old column name.
I probably do something wrong. But I can't see what.
Thanks by advance for any piece of advise.
Best regards. 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
