Re: Sequence Dependency

2023-06-14 Thread Umut TEKİN
Hi, I am sorry for my late response and thanks now it is fine. Thanks! On Mon, Jun 12, 2023 at 4:15 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Saturday, June 10, 2023, Umut TEKİN wrote: > >> it does not create any pg_depend entry for this sequence and table > pair. So, it is not

Re: Sequence Dependency

2023-06-12 Thread Tom Lane
"David G. Johnston" writes: > On Saturday, June 10, 2023, Umut TEKİN 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 met

Re: Sequence Dependency

2023-06-12 Thread David G. Johnston
On Saturday, June 10, 2023, Umut TEKİN 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 a

Sequence Dependency

2023-06-12 Thread Umut TEKİN
Hi, I did not find any relation after reading relevant documents so I need to ask you: When we create a table like this; Method - 1 CREATE TABLE fruits( id SERIAL PRIMARY KEY, name VARCHAR NOT NULL ); it automatically creates a sequence and for that sequence it also creates an entry in