Re: Explicitly setting sequence next value, removes ownership of table of a serial

Поиск
Список
Период
Сортировка
От Aditya Toshniwal
Тема Re: Explicitly setting sequence next value, removes ownership of table of a serial
Дата
Msg-id CAM9w-_nqxT8Bts9R3i4=u9yhPJbGeut9U_43BfUM5K-8NyDM2A@mail.gmail.com
обсуждение исходный текст
Ответ на Explicitly setting sequence next value, removes ownership of table of a serial  ("Regina Obe" <lr@pcorp.us>)
Список pgadmin-hackers
Hi Regina,


On Fri, Feb 10, 2023 at 4:17 AM Regina Obe <lr@pcorp.us> wrote:
I noticed something which might be intentional, but seems odd.

If I do something like:

CREATE TABLE test(id serial, name text);

And then I use the pgAdmin UI to edit the current value of the sequence.
I notice it does this:

ALTER SEQUENCE IF EXISTS public.test_id_seq OWNED BY NONE;
SELECT setval('public.test_id_seq', 2, true);


So then dropping the table, will not drop the sequence.

If I create a table with the generated syntax:

CREATE TABLE test(id integer GENERATED BY DEFAULT AS IDENTITY, name text);

Then go edit, it doesn't try to drop the ownership, just does this

SELECT setval('public.test_id_seq', 2, true);

Is there a reason why pgAdmin drops the ownership?

Thanks,
Regina









--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

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

Предыдущее
От: "Regina Obe"
Дата:
Сообщение: Explicitly setting sequence next value, removes ownership of table of a serial
Следующее
От: Akshay Joshi
Дата:
Сообщение: [pgadmin-org/pgadmin4] 696cb0: Ensure that Grant column permission to a view is v...