I've installed Postgres 14 on Ubuntu 22.04. I use pgAdmin as postgres-User to work on it.
Everything worked fine until after a few days i realized that the superuser privilege was deactivated for the ...
I have some large sets of tables that I partition by date.
Every day I run a query similar to this to merge the two tables
WITH moved_rows AS
DELETE FROM tableA_20230531 RETURNING *
INSERT INTO ...