default value not working?

Поиск
Список
Период
Сортировка
Искать
От
jason.servetar@ccgenesis.com
Тема
default value not working?
Дата
в 10:39:28
Msg-id
309339290B4FD31184BC0060B06888CB01D0F996@CADILLAC
Список
Дерево обсуждения
default value not working? jason.servetar@ccgenesis.com
Re: default value not working? Tom Lane <tgl@sss.pgh.pa.us>
                            version                             
----------------------------------------------------------------
 PostgreSQL 7.1 on sparc-sun-solaris2.6, compiled by GCC 2.95.2

Ok, I ported my Oracle database and my developers started complaining that
their defaults are not working.  Could someone tell me if I am doing
something wrong and what the workaround is. 
If I were not so new to postgres, I would think this is a bug for sure.

I tried the following cases. 

--Example 1 default set null permitted.

gcf_dev=> create table test1(test varchar(1) default 'N');
CREATE

gcf_dev=> insert into  test1 (test) values (null);
INSERT 38096 1

gcf_dev=> select * from test1;
 test 
------
 
(1 row)
--Example 2 default set not null

gcf_dev=> create table test2(test varchar(1) not null default 'N');
CREATE

gcf_dev=> insert into  test2 (test) values (null);
ERROR:  ExecAppend: Fail to add null value in not null attribute test

--Example 3 tried switching order of not null and default in definition
--Also tried inserting empty length string to see if that will get default
to fire 
--No luck.

gcf_dev=> create table test3(test varchar(1) default 'N' not null);
CREATE

gcf_dev=> insert into test3 (test) values (null);
ERROR:  ExecAppend: Fail to add null value in not null attribute test

gcf_dev=> insert into test3 (test) values ('');
INSERT 38119 1

gcf_dev=> select * from test3;
 test 
------
 
(1 row)



В списке pgsql-novice по дате отправления
От: rbird
Дата:
Сообщение: Install of postgresql
От: Stephen M. Ford
Дата:
Сообщение: Re: Install of postgresql
FAQ