Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CLn8x71662 for ; Mon, 12 Feb 2001 16:49:08 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mult.i.pl (pr155.warszawa.sdi.tpnet.pl [213.25.54.155]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CGDJx23822 for ; Mon, 12 Feb 2001 11:17:28 -0500 (EST) (envelope-from tomek@mult.i.pl) Received: (qmail 15797 invoked by uid 500); 12 Feb 2001 16:24:54 -0000 Date: Mon, 12 Feb 2001 17:24:54 +0100 From: Tomek Zielonka To: pgsql Subject: Re: Wierd postgres Problem Message-ID: <20010212172454.A15747@mult.i.pl> References: <3A8950A9.B8D51FCB@mondo-live.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2i In-Reply-To: <3A8950A9.B8D51FCB@mondo-live.com>; from najm@mondo-live.com on Tue, Feb 13, 2001 at 10:20:09AM -0500 X-Archive-Number: 200102/234 X-Sequence-Number: 1425 On Tue, Feb 13, 2001 at 10:20:09AM -0500, Najm Hashmi wrote: > Hi All, hi > 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, [...] > is something wrong with my table definition syntex? Yes, you forgot to specify types for comp_id and dept_id fields. greetings, Tom -- .signature: Too many levels of symbolic links