Re: Sequence Dependency

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Sequence Dependency
Дата
Msg-id CAKFQuwb1s1M7q5ZbnHb-UtMuNLam2Wiam8_sUbY-ohX3S-g2ig@mail.gmail.com
обсуждение исходный текст
Ответ на Sequence Dependency  (Umut TEKİN <umuttechin@gmail.com>)
Ответы Re: Sequence Dependency  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
On Saturday, June 10, 2023, Umut TEKİN <umuttechin@gmail.com> wrote:

it does not create any pg_depend entry for this sequence and table pair. So, it is not possible to track down to find the pairs. Is there any other way to find the sequence and the table pairs created using method 2?

Parse the defaults and check for matching sequence names?

You can alter a manually created sequence to be owned by a table and thus get the dependency added even in the second case.

David J. 

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Further clarification in documentation: No deletion of unreferenced large objects
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Sequence Dependency