<Helen_Yelluas@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
