On Fri, 2020-08-21 at 14:57 +0300, Олег Самойлов wrote:
> Just create partitioned table for PostgreSQL logs
>
> CREATE TABLE pglog.pglog (
> log_time timestamp(3) with time zone,
> [...]
> ) PARTITION BY LIST (date_part('isodow', log_time));
>
> ERROR: functions in partition key expression must be marked IMMUTABLE
Two approaches:
1. Use "timestamp without time zone".
2. Partition in some other way, for example BY RANGE (log_time).
Your list partitions don't make a lot of sense to me.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
