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