Am 25.10.2024 um 17:57 schrieb Adrian
Klaver:
I do not feel it applies to my case. I tried to create a partitioned table that inherits columns from a base table. The documentation you provided the URL seems to speak of realising partitioning by using inheritance.
This needs a code example to go any further.
Sorry, my bad. I posted the URL of the table that is inherited from. The recepient is https://sourceforge.net/p/treintaytres/code/HEAD/tree/trunk/code_files/data_storage/PostgreSQL/tables/TOPO_FILES.pg_sqlcreate table if not exists TOPO_FILES (
SOURCE_ID uuid constraint TOPO_FILES␟FK_01 references SOURCES (ID) match full not null ,FILE_NAME text not null ,TILE raster not null ,FILE_CREATION_PIT timestamp(6) with time zone not null ,FILE_HASH text not null ,constraint TOPO_FILES␟PK primary key (ID) ,constraint TOPO_FILES␟UQ unique (SOURCE_ID ,FILE_NAME) ) inherits(TEMPLATE_TECH); -- partition by hash (source_id); --NOTE Up to PG 17, partitioning with inheriting table is not possible. The spender table is https://sourceforge.net/p/treintaytres/code/HEAD/tree/trunk/code_files/data_storage/PostgreSQL/tables/TEMPLATE_TECH.pg_sql create table if not exists TEMPLATE_TECH ( ID uuid constraint TEMPLATE_TECH␟PK primary key not null default gen_random_uuid() ,ENTRY_PIT timestamp(6) with time zone not null default clock_timestamp() );