| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Plans for partitioning of inheriting tables |
| Date: | 2024-10-25 15:57:31 |
| Message-ID: | 2225b081-1f55-4fc7-8b59-e190f6fdd0c4@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2024-10-25 18:45:19 | Re: Plans for partitioning of inheriting tables |
| Previous Message | Adrian Klaver | 2024-10-25 15:52:59 | Re: Unable to completely uninstall PostgreSQL 14.2 + pgAdmin 6.4 |