Re: Error-safe user functions

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Joe Conway <mail(at)joeconway(dot)com>
Cc:	Andrew Dunstan <andrew(at)dunslane(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Error-safe user functions
Date:	2022-12-05 17:27:42
Message-ID:	3319836.1670261262@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-10-03 19:44:27 from Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru> 📎  2022-10-03 23:13:52 from Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru> 📎  2022-10-07 17:37:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2022-11-15 16:35:55 from Andrew Dunstan <andrew(at)dunslane(dot)net>    2022-11-21 05:17:12 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>     2022-11-21 05:26:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2022-11-21 23:59:38 from Michael Paquier <michael(at)paquier(dot)xyz>      2022-12-01 17:46:48 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎       2022-12-01 18:14:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2022-12-01 19:04:00 from Robert Haas <robertmhaas(at)gmail(dot)com>         2022-12-01 19:41:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2022-12-01 20:12:09 from Robert Haas <robertmhaas(at)gmail(dot)com>           2022-12-01 20:49:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2022-12-01 21:15:17 from Robert Haas <robertmhaas(at)gmail(dot)com>             2022-12-01 22:33:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2022-12-02 13:27:58 from Robert Haas <robertmhaas(at)gmail(dot)com>               2022-12-02 14:12:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2022-12-02 14:34:24 from Andrew Dunstan <andrew(at)dunslane(dot)net>                 2022-12-02 18:15:06 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                  2022-12-02 18:46:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2022-12-02 19:06:09 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                   2022-12-02 20:49:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2022-12-02 21:19:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2022-12-03 21:46:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                  2022-12-04 03:56:49 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                   2022-12-04 04:17:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2022-12-05 15:47:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2022-12-05 16:09:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2022-12-05 16:20:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2022-12-05 16:36:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>                       2022-12-05 16:53:17 from Joe Conway <mail(at)joeconway(dot)com>                        2022-12-05 17:14:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2022-12-05 17:27:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2022-12-05 17:35:34 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2022-12-05 17:38:45 from Joe Conway <mail(at)joeconway(dot)com>                          2022-12-05 17:42:31 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                           2022-12-05 17:51:49 from Andrew Dunstan <andrew(at)dunslane(dot)net>                            2022-12-05 18:00:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2022-12-05 19:23:38 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                             2022-12-05 21:40:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                              2022-12-05 23:47:34 from Andres Freund <andres(at)anarazel(dot)de>                               2022-12-06 00:18:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2022-12-06 00:56:07 from Andres Freund <andres(at)anarazel(dot)de>                                 2022-12-06 01:06:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                  2022-12-06 01:14:04 from Andres Freund <andres(at)anarazel(dot)de>                                   2022-12-06 01:19:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2022-12-06 02:23:23 from Andres Freund <andres(at)anarazel(dot)de>                                     2022-12-06 02:32:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                  2022-12-06 11:46:10 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                   2022-12-06 18:16:59 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                                    2022-12-06 20:21:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                     2022-12-07 13:47:37 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                      2022-12-07 14:20:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2022-12-07 14:51:12 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                       2022-12-07 15:04:01 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                        2022-12-07 15:23:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2022-12-07 15:49:18 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                          2022-12-07 16:06:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                           2022-12-07 16:15:31 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                            2022-12-07 16:59:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                             2022-12-07 17:02:47 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                              2022-12-07 17:20:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2022-12-08 12:00:19 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                        2022-12-07 15:33:11 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                         2022-12-07 20:16:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2022-12-07 22:32:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                           2022-12-07 22:50:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                            2022-12-07 22:56:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                           2022-12-07 23:35:18 from Andres Freund <andres(at)anarazel(dot)de>                                            2022-12-07 23:52:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2022-12-08 16:31:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                             2022-12-08 21:00:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                                              2022-12-08 21:58:36 from Andres Freund <andres(at)anarazel(dot)de>                                               2022-12-08 22:57:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                2022-12-09 02:15:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                2022-12-09 02:33:51 from Andres Freund <andres(at)anarazel(dot)de>                                                 2022-12-09 02:59:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                  2022-12-09 13:06:58 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                   2022-12-09 15:16:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                    2022-12-09 15:37:56 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                     2022-12-09 16:16:34 from Amul Sul <sulamul(at)gmail(dot)com>                                                      2022-12-09 22:54:24 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                                                     2022-12-10 01:28:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                      2022-12-10 12:20:13 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                       2022-12-10 14:20:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                        2022-12-10 17:19:59 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                                                         2022-12-10 21:01:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                     2022-12-10 14:35:12 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                      2022-12-10 15:43:28 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                                                      2022-12-10 19:38:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                       2022-12-10 23:11:35 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                        2022-12-11 00:00:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                         2022-12-11 14:35:40 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                        2022-12-11 17:24:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                         2022-12-11 18:01:36 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                          2022-12-11 18:29:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                           2022-12-13 12:33:19 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                            2022-12-14 12:35:02 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                             2022-12-14 16:00:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                              2022-12-14 21:45:45 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                               2022-12-14 22:37:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2022-12-18 14:42:39 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                 2022-12-21 23:19:52 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                  2022-12-22 06:10:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                   2022-12-23 14:52:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                 2022-12-22 16:44:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2022-12-23 17:19:44 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                   2022-12-23 18:53:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2022-12-24 12:51:25 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                     2022-12-24 15:42:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                      2022-12-24 20:23:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                   2022-12-23 21:19:07 from Ted Yu <yuzhihong(at)gmail(dot)com>                                                                    2022-12-23 21:22:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                     2022-12-23 21:25:42 from Ted Yu <yuzhihong(at)gmail(dot)com>                                                                      2022-12-23 21:38:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                     2022-12-24 09:51:10 from Ted Yu <yuzhihong(at)gmail(dot)com>                                                                      2022-12-24 12:38:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                       2022-12-24 14:28:45 from Ted Yu <yuzhihong(at)gmail(dot)com>                                                                      2022-12-24 15:48:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                              2022-12-14 23:24:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                               2022-12-15 03:33:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                2022-12-15 05:19:45 from Amul Sul <sulamul(at)gmail(dot)com>                                                                 2022-12-15 05:45:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2022-12-15 06:19:24 from Amul Sul <sulamul(at)gmail(dot)com>                                                               2022-12-15 14:12:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                2022-12-15 22:18:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                 2022-12-16 18:31:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2022-12-19 16:34:39 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                   2022-12-19 16:44:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2022-12-19 18:25:19 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                     2022-12-19 21:27:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                      2022-12-19 22:48:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                   2022-12-25 17:13:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                    2022-12-25 20:38:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                    2022-12-26 13:59:08 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                     2022-12-26 17:47:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                      2022-12-26 19:12:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                       2022-12-27 13:31:01 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                                        2022-12-27 17:47:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                         2022-12-27 18:05:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                          2022-12-27 19:51:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                         2022-12-28 06:00:34 from Amul Sul <sulamul(at)gmail(dot)com> 📎                                                                          2022-12-28 15:04:07 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                    2022-12-26 23:00:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                                     2022-12-27 13:36:15 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                    2023-01-03 18:16:40 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                2022-12-17 21:59:00 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                         2022-12-11 20:41:21 from Andres Freund <andres(at)anarazel(dot)de>                                                          2022-12-11 21:23:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2022-12-07 17:01:11 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                                        2022-12-07 17:17:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2022-12-08 03:37:28 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                                       2022-12-07 17:17:25 from Andres Freund <andres(at)anarazel(dot)de>                                     2022-12-07 17:34:27 from Andres Freund <andres(at)anarazel(dot)de>                                      2022-12-07 17:46:26 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                      2022-12-07 17:51:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2022-12-07 18:00:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2022-12-06 14:42:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2022-12-06 15:43:03 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                  2022-12-06 16:07:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                   2022-12-06 17:10:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                                    2022-12-06 20:29:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2022-12-05 19:22:27 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>                        2022-12-05 19:55:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>                      2022-12-05 17:09:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2022-12-05 17:27:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2022-12-05 17:44:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2022-12-05 17:50:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2022-12-04 12:53:15 from Andrew Dunstan <andrew(at)dunslane(dot)net>                   2022-12-04 15:25:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2022-12-04 16:21:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>                     2022-12-04 17:01:33 from Vik Fearing <vik(at)postgresfriends(dot)org>                      2022-12-05 01:17:56 from Michael Paquier <michael(at)paquier(dot)xyz>                2022-12-02 17:53:20 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>  2022-10-10 16:54:28 from Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Error-safe user functions at 2022-12-05 17:14:44 from Tom Lane

Responses

• Re: Error-safe user functions at 2022-12-05 17:35:34 from Robert Haas
• Re: Error-safe user functions at 2022-12-05 17:42:31 from Alvaro Herrera

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Nathan Bossart	2022-12-05 17:35:23	Re: suppressing useless wakeups in logical/worker.c
Previous Message	Robert Haas	2022-12-05 17:27:29	Re: Error-safe user functions