Re: Wierd postgres Problem - Mailing list pgsql-sql

From Tomek Zielonka
Subject Re: Wierd postgres Problem
Date
Msg-id 20010212172454.A15747@mult.i.pl
Whole thread Raw
In response to Wierd postgres Problem  (Najm Hashmi <najm@mondo-live.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: ORDER BY in SQL functions
Next
From: Peter Eisentraut
Date:
Subject: Re: PL/PGSQL Cook Book