Horton
Menu

Re: Plans for partitioning of inheriting tables

Thiemo Kellner <thiemo@gelassene-pferde.biz>

View thread
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To:
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2024-10-25T05:33:16Z
Lists: pgsql-general 
Thanks for taking this up.

24.10.2024 22:44:11 Adrian Klaver <adrian.klaver@aklaver.com>:

> 
> 1) Have you looked at?:
> 
> https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE

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.

> 
> 2) Provide the SQL you ran that got the above error?

https://sourceforge.net/p/treintaytres/code/HEAD/tree/trunk/code_files/data_storage/PostgreSQL/tables/TEMPLATE_TECH.pg_sql