timestamp data type and null value - Mailing list pgsql-admin

From William L James
Subject timestamp data type and null value
Date
Msg-id 39DE3E10.975AAFA5@inetmi.com
Whole thread Raw
List pgsql-admin
Hello there:

I am trying to move one of our databases from MS SQL
to PostgreSQL and having trouble.  One of our table
columns is a timestamp type and the contents in MS SQL
is nulls.  When defined for PostgreSQL, I specifically did
not include the "NOT NULL" attribute to this column, but
when we issue an INSERT with the null, it fails with an
error indicating that nulls are not allowed.  What can I do
to either get the timestamp data type to permit null values
or to redefine my column to accept a timestamp-like type
and nulls.

Thanks,
--
William L. James
I/NET, Inc.
Email: mailto:bjames@inetmi.com
WWW: http://www.inetmi.com



pgsql-admin by date:

Previous
From: Jean-Marc Pigeon
Date:
Subject: Re: Memory bloating
Next
From: "Anton Kalauzky"
Date:
Subject: PostgreSQL encoding question