backend dies when a user defined type returns null

Поиск
Список
Период
Сортировка
От Patrick Robin
Тема backend dies when a user defined type returns null
Дата
Msg-id 3A1B154E.F3D1EF75@fa.disney.com
обсуждение исходный текст
Ответы Re: backend dies when a user defined type returns null  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I created myself a user defined type following the example in the
Postgres programmer's guide.

In the example  in chapter 5  it shows that the input function for the
user defined type returns null when the input type doesn't match the
correct format.

I do that for input strings that don't match my strict n.n.n format ( ex
3.2.1) but it causes the backend to die.

For example, this query causes it to die:

select * from collections where version='3.2'

But this one works because it is in the correct format:

select * from collections where version='3.2.1'


Am I doing something wrong?

Thanks

Patrick

--
________________________________________
Patrick Robin
patrickr@fa.disney.com
Walt Disney Feature Animation
500 South Buena Vista Street
Burbank,California 91521-4817




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Core dumps, i.e. how to track down a problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Transaction, Rollback and Database Corruption question,