PREPARE vs query with MULTIPLE statements
| От | Andrei Kovalevski |
|---|---|
| Тема | PREPARE vs query with MULTIPLE statements |
| Дата | |
| Msg-id | 4743C779.6080904@commandprompt.com обсуждение исходный текст |
| Ответы |
Re: PREPARE vs query with MULTIPLE statements
|
| Список | pgsql-hackers |
Hello. I have found an interesting FRONTEND/BACKEND protocol behaviour. Let's consider following query: "SELECT 1; SELECT 2; SELECT3; SELECT4;" 1) If I send it as a simple query - I'm getting: - correct results for SELECT 1; SELECT 2; SELECT3; SELECT4; - and then one ReadyForQuery response from backend. [send_simple.log & recv_simple.log] 2) If I send it as 'PREPARE "SQL_CUR1" AS SELECT 1; SELECT 2; SELECT3; SELECT4;' and then 'EXECUTE "SQL_CUR1" - I'm getting: - results for SELECT 1; SELECT2; SELECT 3; - ReadyForQuery response - results for SELECT 4; - one more ReadyForQuery response from backend [send_prepared.log & recv_prepared.log] Is this behavour is correct and expected? P.s. Tested on Windows with PostgreSQL 8.0, 8.1 and 8.2 with the same results. Thank You, Andrei. R
В списке pgsql-hackers по дате отправления: