9.3 prepare plans - possible incompatibility

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема 9.3 prepare plans - possible incompatibility
Дата
Msg-id CAFj8pRD32a0D1nuhtqM29UOP5wMEmD34ZcNYFm49qygJ5xTyGA@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hello

I am not sure so replanning prepared plans due change of search_path is expected in all use cases. Minimally it should be mentioned as possible incompatibility.

Use case - move record from schema A to schema B with prepared statements

SET search_path = 'A';
PREPARE x(int) AS DELETE FROM tab WHERE id = $1 RETURNING *;

SET search_path = 'B';
PREPARE y(int, int) AS INSERT INTO tab VALUES($1, $2);

EXECUTE x;
EXECUTE y(10,20);

This use case will not work in 9.3.

Regards

Pavel

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

Предыдущее
От: Marko Kreen
Дата:
Сообщение: Re: erroneous restore into pg_catalog schema
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: Add more regression tests for dbcommands