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

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

Re: Further clarification in documentation: No deletion of unreferenced large objects

2023-06-12 Thread Erik Wienhold
> On 12/06/2023 15:48 CEST PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/datatype-binary.html > Description: > > When deleting a row that references (contains) a large object, I think that > most

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

Further clarification in documentation: No deletion of unreferenced large objects

2023-06-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-binary.html Description: When deleting a row that references (contains) a large object, I think that most users expect the DBMS to take care of the, now unreferenced, BLOB. It's

Re: Further clarification in documentation: No deletion of unreferenced large objects

2023-06-12 Thread Laurenz Albe
On Mon, 2023-06-12 at 13:48 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/15/datatype-binary.html > > When deleting a row that references (contains) a large object, I think that > most users expect the DBMS to take care of the, now unreferenced, BLOB. It's > good to

Re: Further clarification in documentation: No deletion of unreferenced large objects

2023-06-12 Thread David G. Johnston
On Mon, Jun 12, 2023 at 8:32 AM PG Doc comments form wrote: You may be onto something, but: > > Page: https://www.postgresql.org/docs/15/datatype-binary.html This page isn't relevant to the discussion at hand as it doesn't have anything to do with large objects. Whether it should would be a