is date_part immutable or not?

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: is date_part immutable or not?
Date: 2020-08-21 11:57:01
Message-ID: 23C20954-7FEF-4132-9BF3-1F8FBD8E1F07@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgreSQL 12.4
Just create partitioned table for PostgreSQL logs

CREATE TABLE pglog.pglog (
log_time timestamp(3) with time zone,
user_name text,
database_name text,
process_id integer,
connection_from text,
session_id text,
session_line_num bigint,
command_tag text,
session_start_time timestamp with time zone,
virtual_transaction_id text,
transaction_id bigint,
error_severity text,
sql_state_code text,
message text,
detail text,
hint text,
internal_query text,
internal_query_pos integer,
context text,
query text,
query_pos integer,
location text,
application_name text
) PARTITION BY LIST (date_part('isodow', log_time));

ERROR: functions in partition key expression must be marked IMMUTABLE

But, date_part is immutable

Schema | pg_catalog
Name | date_part
Result data type | double precision
Argument data types | text, time with time zone
Type | func
Volatility | immutable
Parallel | safe
Owner | postgres
Security | invoker
Access privileges |
Language | internal
Source code | timetz_part
Description | extract field from time with time zone

What is wrong here?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Boussekey 2020-08-21 12:00:00 When are largobject records TOASTed into pg_toast_2613?
Previous Message Paul Förster 2020-08-21 10:17:14 Re: > ERROR: syntax error at or near "BYTE"