pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (4+ messages)  latest in thread

Message-ID: <20010212172454.A15747@mult.i.pl>
Permalink:  ../20010212172454.A15747@mult.i.pl/
Also on:    postgresql.org/message-id/20010212172454.A15747@mult.i.pl

 · 

reply

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