Table cannot be partiotioned using domain in argument

From: Márcio Antônio Sepp <marcio(at)zyontecnologia(dot)com(dot)br>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Table cannot be partiotioned using domain in argument
Date: 2018-09-12 02:11:57
Message-ID: 012d01d44a3d$fb7c6100$f2752300$@com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

This query works fine:

create table t1

(d date)

PARTITION BY RANGE (d);

CREATE TABLE t1_p1 PARTITION OF t1 FOR VALUES FROM ('2000-01-01') TO
('2019-01-01');

Same query, but now (using domain):

CREATE DOMAIN ddate

AS date;

create table t1

(d ddate)

PARTITION BY RANGE (d);

CREATE TABLE t1_p1 PARTITION OF t1 FOR VALUES FROM ('2000-01-01') TO
('2019-01-01');

The follow error occur:

SQL Error [42804]: ERROR: specified value cannot be cast to type ddate for
column "d"

Detalhe: The cast requires a non-immutable conversion.

Dica: Try putting the literal value in single quotes.

Posição: 55

I cannot use domain in this case?

Thanks in advance!

--

Att

Márcio

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-09-12 03:20:49 Re: Table cannot be partiotioned using domain in argument
Previous Message Michael Paquier 2018-09-11 22:24:24 Re: scram-sha-256 authentication broken in FIPS mode