Error messages --- now that we've got it, do you like it?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Error messages --- now that we've got it, do you like it?
Дата
Msg-id 12322.1057287718@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Error messages --- now that we've got it, do you like  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: Error messages --- now that we've got it, do you like  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
First fruits of all that work on error message rejiggering ...

regression=# \set VERBOSE terse

regression=# select 1!! ;
ERROR:  operator does not exist: integer !!

regression=# \set VERBOSE default

regression=# select 1!! ;
ERROR:  operator does not exist: integer !!
HINT:  No operator matches the given name and argument type(s). You may need to add explicit typecasts.

regression=# \set VERBOSE verbose

regression=# select 1!! ;
ERROR:  42883: operator does not exist: integer !!
HINT:  No operator matches the given name and argument type(s). You may need to add explicit typecasts.
LOCATION:  op_error, parse_oper.c:691

regression=# select 'z' && 'q';
ERROR:  42725: operator is not unique: "unknown" && "unknown"
HINT:  Unable to choose a best candidate operator. You may need to add explicit typecasts.
LOCATION:  op_error, parse_oper.c:684

Before we go too much further, does this look sane to people?
Any adjustments you want to make around the edges?

(BTW, if you're wondering where the 42xxx error codes came from,
I borrowed them from DB2.  The SQL99 spec seems happy to lump
all sorts of conditions under 42000 "syntax error or access
violation" ...)
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: btree index growth
Следующее
От: Tom Lane
Дата:
Сообщение: Re: btree index growth