<Helen_Yelluas(at)McAfee(dot)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