Weirdness in CHECK?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Weirdness in CHECK?
Дата
Msg-id NEBBIOAJBMEENKACLNPCOEMNCCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Weirdness in CHECK?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I just ran across this recent example:

If you perform the following, you get a truncated input:

test=# create table example (type char(5) NOT NULL);
CREATE
test=# insert into example VALUES ('VOLUME');
INSERT 156884 1
test=# select * from example;type
-------VOLUM
(1 row)

However, if you add CHECK in that checks for a string that is LONGER than
the CHAR(5), you get this:

test=# create table example(type char(5) NOT NULL CHECK (type IN
('MASS','VOLUME')));
CREATE
test=# insert into example VALUES ('VOLUME');
ERROR:  ExecAppend: rejected due to CHECK constraint example_type

Is this correct behaviour?  Perhaps it is, as CHECK is checking the
truncated value - but I just want to make sure it's not a bug!

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: Please review TODO list
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Please review TODO list