On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
> > Of the functions the only one that will use constraint_exclusion is the
> > one that explicitly passes the date value.
>
> Since you haven't shown us the constraints you're talking about, or the
> resulting plans, it's difficult for anyone to guess what's going on.
Table "public.foo_stats_day" Column | Type | Modifiers
------------------+---------+-----------a_serv_id | integer | not nullday | date | not
nullnum_leads | integer | num_subscribed | integer | num_unsubscribed | integer | num_unverified | integer |
Indexes: "foo_stats_day_pkey" PRIMARY KEY, btree (a_serv_id, day)
Triggers: partion_public_foo_stats_day_trigger BEFORE INSERT OR UPDATE ON
lead_stats_day FOR EACH ROW EXECUTE PROCEDURE
partion_public_foo_stats_day()
app=# \d year_2007.foo_stats_day_q1 Table "year_2007.foo_stats_day_q1" Column | Type | Modifiers
------------------+---------+-----------a_serv_id | integer | not nullday | date | not
nullnum_leads | integer | num_subscribed | integer | num_unsubscribed | integer | num_unverified | integer |
Indexes: "foo_stats_day_pkey_q1" PRIMARY KEY, btree (a_serv_id, day),
tablespace "year_2007_indexes"
Check constraints: "foo_stats_day_q1_day_check" CHECK (day >= '2007-01-01'::date AND
day < '2007-04-01'::date)
Inherits: foo_stats_day
Tablespace: "year_2007"
I am not sure which plans I should show you as they are function plans
thereby not very useful.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
--
PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL
Company,serving since 1997