Hello,
It seems as if pg_dump is not properly dumping the UNLOGGED flag on partitioned tables.
Please find a reproduction script:
$ createdb foobar
$ psql postgresql://localhost:5432/foobar
# SHOW server_version;
server_version
---------------------------------
17.10 (Debian 17.10-1.pgdg12+1)
# CREATE UNLOGGED TABLE zde (id bigint) PARTITION BY RANGE(id);
[...]
$ pg_dump --version
pg_dump (PostgreSQL) 18.4
$ pg_dump --no-data 'dbname=foobar'
[...]
CREATE TABLE public.zde (
id bigint
)
PARTITION BY RANGE (id);
[...]
Kind regards,
Quentin de Metz
