[COMMITTERS] pgsql: Fix ALTER SEQUENCE OWNED BY to not rewrite the sequencerelation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема [COMMITTERS] pgsql: Fix ALTER SEQUENCE OWNED BY to not rewrite the sequencerelation
Дата
Msg-id E1dKWP6-000544-1R@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix ALTER SEQUENCE OWNED BY to not rewrite the sequence relation.

It's not necessary for it to do that, since OWNED BY requires only ordinary
catalog updates and doesn't affect future sequence values.  And pg_upgrade
needs to use OWNED BY without having it change the sequence's relfilenode.
Commit 3d79013b9 broke this by making all forms of ALTER SEQUENCE change
the relfilenode; that seems to be the explanation for the hard-to-reproduce
buildfarm failures we've been seeing since then.

Discussion: https://postgr.es/m/19785.1497215827@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a475e46634dc7abde1d5a6fc7aaa708219383004

Modified Files
--------------
src/backend/commands/sequence.c | 76 ++++++++++++++++++++++++++++-------------
1 file changed, 53 insertions(+), 23 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: [COMMITTERS] pgsql: doc: Update information_schema documentation for identitycolumn
Следующее
От: Tom Lane
Дата:
Сообщение: [COMMITTERS] pgsql: Assert that we don't invent relfilenodes or type OIDs inbinary