Table cannot be partiotioned using domain in argument

[Márcio Antônio Sepp]

 

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