Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1CFE8x10810 for ; Mon, 12 Feb 2001 10:14:08 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@ll20.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id OAA06221 for ; Mon, 12 Feb 2001 14:34:16 GMT Message-ID: <3A8950A9.B8D51FCB@mondo-live.com> Date: Tue, 13 Feb 2001 10:20:09 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql Subject: Wierd postgres Problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/209 X-Sequence-Number: 1399 Hi All, I am trying to define a new set of tables an I am getting this strange syntex problem on date, or timestamp data types. I am also getting error on not null constranit as well... Postgres is behaving strangely.... first definations with not null cmdb=# create table media_received ( cmdb(# comp_id not null, cmdb(# dept_id not null, cmdb(# date_rec timestamp default 'now', cmdb(# units int4 default 0, cmdb(# media_type varchar(64), cmdb(# enqued int4 check (enqued=