Re: BUG #3236: Partitioning has problem with timestamp and timestamptz data type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christian Gonzalez" <christian(dot)gonzalez(at)sigis(dot)com(dot)ve>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3236: Partitioning has problem with timestamp and timestamptz data type
Date: 2007-04-18 17:24:27
Message-ID: 5435.1176917067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2007-04-18 21:23:00 Re: BUG #3237: function to_char() returns wrong value
Previous Message junk 2007-04-18 09:16:47 BUG #3239: French translation error