timestamp data type and null value

Поиск
Список
Период
Сортировка
От William L James
Тема timestamp data type and null value
Дата
Msg-id 39DE3E10.975AAFA5@inetmi.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jean-Marc Pigeon
Дата:
Сообщение: Re: Memory bloating
Следующее
От: "Anton Kalauzky"
Дата:
Сообщение: PostgreSQL encoding question