Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group