Re: Looking for context around which event triggers are permitted

2023-07-17 Thread Garrett Thornburg
That makes sense and is similar to the problem I'm hoping to solve for our team. We had a DB upgrade that corrupted a few indexes. Gitlab went through something similar as part of their OS/ DB upgrade. We had to concurrently reindex everything. This took a few days and just to make sure we

Re: Looking for context around which event triggers are permitted

2023-07-17 Thread Aleksander Alekseev
Hi, > Happy to enable those with a patch if it's as Aleksander said. Meaning, no > real reason they were disabled other than someone thought folks wouldn't need > them. Sure, please feel free submitting the patch and we will see how it goes. I don't foresee a strong push-back from the

Re: Looking for context around which event triggers are permitted

2023-07-17 Thread Alvaro Herrera
On 2023-Jul-17, Garrett Thornburg wrote: > That's a good point, Isaac. Select into, security label, comment, etc are > all maintenance style commands but are already added to the matrix. I do > think there's a good case to include other maintenance related commands as > event triggers. Suppose

Re: Looking for context around which event triggers are permitted

2023-07-17 Thread Garrett Thornburg
That's a good point, Isaac. Select into, security label, comment, etc are all maintenance style commands but are already added to the matrix. I do think there's a good case to include other maintenance related commands as event triggers. Suppose you want to know the last time a table was vacuumed

Re: Looking for context around which event triggers are permitted

2023-07-17 Thread Isaac Morland
On Mon, 17 Jul 2023 at 11:26, Aleksander Alekseev wrote: > Hi, > > > I was working on a project with event triggers and was wondering if > there was any context from the developers around why some things make this > list and others do not. Example: REVOKE/ GRANT are in the event trigger > matrix

Re: Looking for context around which event triggers are permitted

2023-07-17 Thread Aleksander Alekseev
Hi, > I was working on a project with event triggers and was wondering if there was > any context from the developers around why some things make this list and > others do not. Example: REVOKE/ GRANT are in the event trigger matrix [1] but > REINDEX is not. Just wondering if there's a mailing

Looking for context around which event triggers are permitted

2023-07-17 Thread Garrett Thornburg
Hey list, I was working on a project with event triggers and was wondering if there was any context from the developers around why some things make this list and others do not. Example: REVOKE/ GRANT are in the event trigger matrix [1] but REINDEX is not. Just wondering if there's a mailing list