[SQL] Wierd postgres Problem

2001-02-12 Thread Najm Hashmi
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 (

Re: [SQL] Wierd postgres Problem

2001-02-12 Thread Peter Eisentraut
Najm Hashmi writes: cmdb=# create table media_received ( cmdb(# comp_id not null, cmdb(# dept_id not null, ^ Those two fields should have a data type. Same in your other examples. cmdb(# date_rec timestamp default 'now', cmdb(# units int4 default 0, cmdb(# media_type

Re: [SQL] Wierd postgres Problem

2001-02-12 Thread Michael Fork
Your missing your fields types, i.e.: CREATE TABLE media_received ( comp_id SERIAL NOT NULL, dept_id INT4NOT NULL, date_recTIMESTAMP DEFAULT 'now', that should fix your problem... Michael Fork - CCNA - MCP - A+ Network

Re: [SQL] Wierd postgres Problem

2001-02-12 Thread Tomek Zielonka
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