Re: Schema variables - new implementation for Postgres 15 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Schema variables - new implementation for Postgres 15
Date
Msg-id CAFj8pRBO-LuSurrYNwQ5-ooJaUMa8QMy9=B83bRN2e1dz3OcbA@mail.gmail.com
Whole thread Raw
In response to Re: Schema variables - new implementation for Postgres 15  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Schema variables - new implementation for Postgres 15
List pgsql-hackers
Hi

ne 23. 1. 2022 v 16:06 odesílatel Julien Rouhaud <rjuju123@gmail.com> napsal:
Hi, 

Le dim. 23 janv. 2022 à 22:34, Pavel Stehule <pavel.stehule@gmail.com> a écrit :
I tested it now. a sinval message is waiting on the transaction end.  So when a variable is used, then it is working fine until the transaction ends.
But when the session makes some DDL, then send sinval to self, and at this moment, the variable can be dropped before the transaction ends.

a backend can accept sinval in very common scenarios, like acquiring a heavyweight lock. That includes accessing a relation thats not in the catcache, so that's really critical to have a protection here. 

here is updated patch with locking support

Regards

Pavel
 
Attachment

pgsql-hackers by date:

Previous
From: "wangsh.fnst@fujitsu.com"
Date:
Subject: RE: drop tablespace failed when location contains .. on win32
Next
From: Michael Paquier
Date:
Subject: Re: drop tablespace failed when location contains .. on win32