From: Tomek Zielonka <tomek@mult.i.pl>
To: pgsql <pgsql-sql@postgresql.org>
Subject: Re: Wierd postgres Problem
Date: Mon, 12 Feb 2001 17:24:54 +0100
Message-ID: <20010212172454.A15747@mult.i.pl> (raw)
In-Reply-To: <3A8950A9.B8D51FCB@mondo-live.com>
References: <3A8950A9.B8D51FCB@mondo-live.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: tomek@mult.i.pl
Subject: Re: Wierd postgres Problem
In-Reply-To: <20010212172454.A15747@mult.i.pl>
References: <3A8950A9.B8D51FCB@mondo-live.com> <20010212172454.A15747@mult.i.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox