Re: Sequence Dependency

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Umut TEKİN <umuttechin(at)gmail(dot)com>
Cc: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Sequence Dependency
Date: 2023-06-12 14:01:11
Message-ID: CAKFQuwb1s1M7q5ZbnHb-UtMuNLam2Wiam8_sUbY-ohX3S-g2ig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Saturday, June 10, 2023, Umut TEKİN <umuttechin(at)gmail(dot)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.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2023-06-12 14:15:19 Re: Sequence Dependency
Previous Message PG Doc comments form 2023-06-12 13:48:23 Further clarification in documentation: No deletion of unreferenced large objects