Re: proposal: schema variables

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: proposal: schema variables
Дата
Msg-id CAB-JLwZfrsXZVOVVANieoPixKVRc_4HORVbkCPoSOLJe4DNXLw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: schema variables  (Dmitry Dolgov <9erthalion6@gmail.com>)
Ответы Re: proposal: schema variables
Список pgsql-hackers
Em ter., 19 de nov. de 2024 às 16:15, Pavel Stehule <pavel.stehule@gmail.com> escreveu:
I wrote POC of VARIABLE(varname) syntax support

Not related with POC of VARIABLE but seeing your patches ...

Wouldn't it be better to use just one syntax and message for what to do ON COMMIT ?

When creating a new variable you use 
CREATE VARIABLE ... ON COMMIT DROP | ON TRANSACTION END RESET

On PSQL \dV+ you show 
Transactional end action

Maybe all them could be just ON COMMIT
CREATE VARIABLE ... [ON COMMIT {NO ACTION, DROP, RESET}] and \dV+ just "on commit" on title column

regards
Marcos

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