Re: search_path for PL/pgSQL functions partially cached?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: search_path for PL/pgSQL functions partially cached?
Дата
Msg-id CAFj8pRC70kmnPKhNCNJ9y+v3gRBTEUTpWs9kbTQL_c3i58QnEQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: search_path for PL/pgSQL functions partially cached?  (Jan Behrens <jbe-mlist@magnetkern.de>)
Список pgsql-general
Hi


Maybe not many people run into these issues because schemas and
functions aren't used as often in combination?

I think schema and functions are common combinations. But when people have objects with the same name, then they are careful to be sure, so objects have really identical structure.
Using different types in these objects is very rare. And because Postgres doesn't support it well, experienced developers don't use it. Similar issues can do some issues after an stored procedures update, because can require session reset. Or when you need it, you can use a much more dynamic type like record.


Kind Regards
Jan Behrens


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