Re: constraint partition issue - Mailing list pgsql-general

<Helen_Yelluas@McAfee.com> writes:
> CREATE TABLE summary_total
> (
>   counter bigint DEFAULT 0,
>   destgeo_id integer DEFAULT 1,
>   direction integer DEFAULT 1,
>   mlapp_id integer DEFAULT 1
> )

> CREATE TABLE summary_daily_data
> (
> )
> INHERITS (summary_total)

> CREATE TABLE summ_dly_1505500
> (
> )
> INHERITS (summary_daily_data)
> ALTER TABLE summ_dly_1505500
>   ADD CONSTRAINT ch_date CHECK
> (datex >= '2011-03-22 00:00:00'::timestamp without time zone AND
>  datex < '2011-03-23 00:00:00'::timestamp without time zone);

Um ... datex is coming from where, again?

            regards, tom lane