Re: What do I do with this error?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What do I do with this error?
Дата
Msg-id 20790.985028911@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: What do I do with this error?  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
"Josh Berkus" <josh@agliodbs.com> writes:
> Tom,
>> regression=# select 'foo' ~* '';
>> ERROR:  regcomp failed with error empty (sub)expression
>> 
>> This is correct according to the POSIX definition of regular
>> expressions
>> ("A (modern) RE is one or more non-empty branches ...").

> That sounds like what I'm seeing!  And now that you point it out, there
> is a bug in the PHP that calls this function that passes an empty string
> ('') instead of a NULL.  Thanks!

> Any possibility that that error message could be made more informative?
> (i.e. ERROR:  regcomp failed due to empty string in regular expression)

You're right, this isn't a very transparent message.  Perhaps
ERROR: Invalid regular expression (empty expression or subexpression)

Comments, better wordings?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Invalid (null) int8, can't convert to float8
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: What do I do with this error?