Re: Create syscaches for pg_extension

2024-09-07 Thread Michael Paquier
On Fri, Sep 06, 2024 at 08:29:52AM +0900, Michael Paquier wrote: > Looks OK at quick glance. I'll take care of that as I've done the > other one. And done. -- Michael signature.asc Description: PGP signature

Re: Create syscaches for pg_extension

2024-09-05 Thread Michael Paquier
On Thu, Sep 05, 2024 at 10:56:34PM +0200, Jelte Fennema-Nio wrote: > LGTM now. Added it to the commitfest here: > https://commitfest.postgresql.org/50/5241/ Looks OK at quick glance. I'll take care of that as I've done the other one. -- Michael signature.asc Description: PGP signature

Re: Create syscaches for pg_extension

2024-09-05 Thread Jelte Fennema-Nio
On Thu, 5 Sept 2024 at 22:03, Andrei Lepikhov wrote: > Thanks, see new patch in attachment. LGTM now. Added it to the commitfest here: https://commitfest.postgresql.org/50/5241/

Re: Create syscaches for pg_extension

2024-09-05 Thread Andrei Lepikhov
On 5/9/2024 18:50, Jelte Fennema-Nio wrote: On Thu, 5 Sept 2024 at 15:41, Andrei Lepikhov wrote: It seems that the get_extension_oid routine was not modified when the sys cache was introduced. What is the reason? It may be that this routine is redundant now, but if not, and we want to hold the

Re: Create syscaches for pg_extension

2024-09-05 Thread Jelte Fennema-Nio
On Thu, 5 Sept 2024 at 15:41, Andrei Lepikhov wrote: > It seems that the get_extension_oid routine was not modified when the > sys cache was introduced. What is the reason? It may be that this > routine is redundant now, but if not, and we want to hold the API that > extensions use, maybe we shoul

Re: Create syscaches for pg_extension

2024-09-05 Thread Pavel Stehule
čt 5. 9. 2024 v 15:41 odesílatel Andrei Lepikhov napsal: > On 22/8/2024 03:49, Michael Paquier wrote: > > On Mon, Aug 19, 2024 at 03:21:30PM +0900, Michael Paquier wrote: > >> I won't hide that I've wanted that in the past.. > > > > And I have bumped into a case where this has been helpful today,

Re: Create syscaches for pg_extension

2024-09-05 Thread Andrei Lepikhov
On 22/8/2024 03:49, Michael Paquier wrote: On Mon, Aug 19, 2024 at 03:21:30PM +0900, Michael Paquier wrote: I won't hide that I've wanted that in the past.. And I have bumped into a case where this has been helpful today, so applied. Thanks! It had been my dream, too, for years. But the reaso

Re: Create syscaches for pg_extension

2024-08-21 Thread Michael Paquier
On Mon, Aug 19, 2024 at 03:21:30PM +0900, Michael Paquier wrote: > I won't hide that I've wanted that in the past.. And I have bumped into a case where this has been helpful today, so applied. Thanks! -- Michael signature.asc Description: PGP signature

Re: Create syscaches for pg_extension

2024-08-18 Thread Michael Paquier
On Tue, Aug 13, 2024 at 05:38:55PM +0300, Alexander Korotkov wrote: > +1 from me too I won't hide that I've wanted that in the past.. -- Michael signature.asc Description: PGP signature

Re: Create syscaches for pg_extension

2024-08-13 Thread Alexander Korotkov
On Tue, Aug 13, 2024 at 5:23 PM Pavel Stehule wrote: > út 13. 8. 2024 v 16:13 odesílatel Jelte Fennema-Nio > napsal: >> >> Shared libraries of extensions might want to invalidate or update their >> own caches whenever a CREATE/ALTER/DROP EXTENSION command is run for >> their extension (in any ba

Re: Create syscaches for pg_extension

2024-08-13 Thread Pavel Stehule
út 13. 8. 2024 v 16:13 odesílatel Jelte Fennema-Nio napsal: > Shared libraries of extensions might want to invalidate or update their > own caches whenever a CREATE/ALTER/DROP EXTENSION command is run for > their extension (in any backend). Right now this is non-trivial to do > correctly and effi

Create syscaches for pg_extension

2024-08-13 Thread Jelte Fennema-Nio
06a21c34594351565a331d0a8353dcf78dc76159 Mon Sep 17 00:00:00 2001 From: Jelte Fennema-Nio Date: Tue, 13 Aug 2024 16:00:22 +0200 Subject: [PATCH v1] Create syscaches for pg_extension Shared libraries of extensions might want to invalidate or update their own caches whenever a CREATE/ALTER/DROP EXTENSION