Re: Which cursor-related warnings should be errors?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Which cursor-related warnings should be errors?
Дата
Msg-id Pine.LNX.4.44.0308242308030.6464-100000@peter.localdomain
обсуждение исходный текст
Список pgsql-hackers
Since no one responded to the message below (posted on pgsql-sql), I made
the change from warning to error in the indicated cases.


> Fetching from a non-existent cursor:
>
> peter=# FETCH ALL FROM non_existent;
> WARNING:  portal "non_existent" does not exist
> FETCH 0
>
> Closing a non-existent cursor:
>
> peter=# CLOSE non_existent;
> WARNING:  portal "non_existent" does not exist
> CLOSE CURSOR
>
> Declaring a new cursor that uses a name already in use:
>
> peter=# BEGIN;
> BEGIN
> peter=# DECLARE foo CURSOR FOR SELECT 1;
> DECLARE CURSOR
> peter=# DECLARE foo CURSOR FOR SELECT 2;
> WARNING:  Closing pre-existing portal "foo"
> DECLARE CURSOR
>
> So if anyone can come up with a reason that theses WARNING: messages
> should not be changed to errors, please speak up.

-- 
Peter Eisentraut   peter_e@gmx.net



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

Предыдущее
От: Jason Tishler
Дата:
Сообщение: Re: PostgreSQL 7.4 Beta 1 + SSL + Cygwin
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: ambiguous sql states