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 (
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
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
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