| From: | Tomek Zielonka <tomek(at)mult(dot)i(dot)pl> |
|---|---|
| To: | pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Wierd postgres Problem |
| Date: | 2001-02-12 16:24:54 |
| Message-ID: | 20010212172454.A15747@mult.i.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fork | 2001-02-12 16:28:30 | Re: plpgsql grief |
| Previous Message | Peter Eisentraut | 2001-02-12 16:15:35 | Re: Wierd postgres Problem |