Re: psql and regex not like

2025-03-13 Thread Renan Alves Fonseca
Another dirty hack: MAGIC=\! psql -Xc "select datname from pg_database WHERE datname $MAGIC~ 'template|postgres' ORDER BY datname;" Em qui., 6 de mar. de 2025 às 10:38, Ron Johnson escreveu: > This statement runs great from the psql prompt. Does exactly what I want. > select datname from pg_da

Re: Querying one partition in a function takes locks on all partitions

2025-03-31 Thread Renan Alves Fonseca
On Mon, Mar 31, 2025 at 5:10 AM David Rowley wrote: > > On Sat, 29 Mar 2025 at 10:30, Renan Alves Fonseca > wrote: > > Currently, in the SQL function path the plan is always generic. The > > planner ignores the function arguments. The plan_cache_mode setting > >

Re: Querying one partition in a function takes locks on all partitions

2025-03-28 Thread Renan Alves Fonseca
y to me. As you say, force_custom_plan > doesn't seem to help with a SQL function - just tested that. > Thanks for noting. I've seen just now. > Regards, > Evgeny Morozov > > On 23/03/2025 12:08 am, Renan Alves Fonseca wrote: > > It seems that when we create a function using pur