From: | "Christian Gonzalez" <christian(dot)gonzalez(at)sigis(dot)com(dot)ve> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | RV: BUG #3236: Partitioning has problem with timestamp and timestamptz data type |
Date: | 2007-04-25 12:57:17 |
Message-ID: | 002501c78739$52348dd0$4802a8c0@sigis.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I'm sorry Tom, you are right.
Atentamente,
Soluciones Integrales GIS C.A (SIGIS)
Christian Gonzalez
christian(dot)gonzalez(at)sigis(dot)com(dot)ve
-----Mensaje original-----
De: pgsql-bugs-owner(at)postgresql(dot)org [mailto:pgsql-bugs-owner(at)postgresql(dot)org]
En nombre de Tom Lane
Enviado el: Miércoles, 18 de Abril de 2007 01:24 p.m.
Para: Christian Gonzalez
CC: pgsql-bugs(at)postgresql(dot)org
Asunto: Re: [BUGS] BUG #3236: Partitioning has problem with timestamp and
timestamptz data type
"Christian Gonzalez" <christian(dot)gonzalez(at)sigis(dot)com(dot)ve> writes:
> When you use timestamp and timestamptz data type for partitioning
> implementation, your postgresql partitioning implementation doesen't
> work fine when you make a SELECT using this columns type.
Your example is a bit silly, since you created a table partitioned on
logdate, then added two unrelated columns and expected the system to assume
the table was partitioned on those. I suppose this is a mistake in the
example, but it's not clear what the real complaint is.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Este mensaje ha sido analizado por MailScanner en busca de virus y otros
contenidos peligrosos, y se considera que está limpio.
--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-04-25 13:44:47 | Re: Postmaster can't stop with pg_ctl |
Previous Message | takuya koide | 2007-04-25 08:28:02 | Postmaster can't stop with pg_ctl |