Horton
Menu

Re: Plans for partitioning of inheriting tables

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Thiemo Kellner <thiemo@gelassene-pferde.biz>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2024-10-25T15:57:31Z
Lists: pgsql-general 
On 10/24/24 22:33, Thiemo Kellner wrote:
> 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.

This needs a code example to go any further.

> 
>>
>> 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
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com