| From: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Erik Rijkers <er(at)xs4all(dot)nl>, Michael Paquier <michael(at)paquier(dot)xyz>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, DUVAL REMI <REMI(dot)DUVAL(at)cheops(dot)fr>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: proposal: schema variables |
| Date: | 2024-11-20 13:29:10 |
| Message-ID: | CAB-JLwZfrsXZVOVVANieoPixKVRc_4HORVbkCPoSOLJe4DNXLw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Em ter., 19 de nov. de 2024 às 16:15, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2024-11-20 13:33:01 | Re: CSN snapshots in hot standby |
| Previous Message | Andrey M. Borodin | 2024-11-20 12:58:11 | Re: cannot freeze committed xmax |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2024-11-20 13:52:16 | Re: proposal: schema variables |
| Previous Message | Frédéric Yhuel | 2024-11-20 10:35:20 | Re: Has gen_random_uuid() gotten much slower in v17? |