| 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: | Whole Thread | Raw Message | 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
| 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 |