Re: BUG #3236: Partitioning has problem with timestamp and timestamptz data type - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3236: Partitioning has problem with timestamp and timestamptz data type
Date
Msg-id 5435.1176917067@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3236: Partitioning has problem with timestamp and timestamptz data type  ("Christian Gonzalez" <christian.gonzalez@sigis.com.ve>)
List pgsql-bugs
"Christian Gonzalez" <christian.gonzalez@sigis.com.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

pgsql-bugs by date:

Previous
From: Russell Smith
Date:
Subject: Re: Grantor name gets lost when grantor role dropped
Next
From: ""
Date:
Subject: BUG #3239: French translation error