RESET SESSION
От | Marko Kreen |
---|---|
Тема | RESET SESSION |
Дата | |
Msg-id | e51f66da0703300559m595106f4t24719df91412b2b8@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: RESET SESSION
Re: RESET SESSION |
Список | pgsql-patches |
This is draft version, for discussion. New commands: CLOSE ALL DEALLOCATE ALL RESET PLANS RESET TEMPS -- please suggest better name RESET SESSION So in the end RESET SESSION basically executes following commands: ABORT; DEALLOCATE ALL; CLOSE ALL; RESET ALL; SET SESSION AUTHORIZATION DEFAULT; UNLISTEN *; RESET TEMPS; RESET PLANS; I think CLOSE ALL and DEALLOCATE ALL are useful in their own, without considering poolers. They just make user lives easier. The ALL just fits there. RESET PLANS and RESET TEMPS are for the principle that components for RESET SESSION should be available for users for special-case situations and fine-tuning poolers. Also they add very little complexity. (RESET PLANS could be useful its awn also). Todo: * Docs * Disallow some commands inside TX? * DEALLOCATE PREPARE ALL gives bison conflicts. is it needed? * Send more details to client. Variants: - CommandComplete: "RESET XXX", "CLOSE ALL", "DEALLOCATE ALL" (CLOSE name and DEALLOCATE name would be good in normal case too, that help anyone who wants to track what exists) - RESET SESSION should send ParamStatus of all parms -- marko
Вложения
В списке pgsql-patches по дате отправления: