Re: Sequence Dependency - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Sequence Dependency
Date
Msg-id CAKFQuwb1s1M7q5ZbnHb-UtMuNLam2Wiam8_sUbY-ohX3S-g2ig@mail.gmail.com
Whole thread Raw
In response to Sequence Dependency  (Umut TEKİN <umuttechin@gmail.com>)
Responses Re: Sequence Dependency
List 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 by date:

Previous
From: PG Doc comments form
Date:
Subject: Further clarification in documentation: No deletion of unreferenced large objects
Next
From: Tom Lane
Date:
Subject: Re: Sequence Dependency