Hi,
On Thu, Jun 12, 2025 at 2:40 AM Tom Lane wrote:
>
> Daniil Davydov <3daniss...@gmail.com> writes:
> > Ability to do a DROP temporary table of other session leads to error :
>
> [ shrug... ] Don't do that. A superuser is capable of doing lots
> of things that will break the database, and thi
Daniil Davydov <3daniss...@gmail.com> writes:
> Ability to do a DROP temporary table of other session leads to error :
[ shrug... ] Don't do that. A superuser is capable of doing lots
of things that will break the database, and this one hardly seems
like one of the worse ones.
> BTW, there are
Hi,
Ability to do a DROP temporary table of other session leads to error :
session 1 :
create temp table test (id int);
-- let's assume that 'test' will be placed in schema 'pg_temp_0' and
has relfilepath 'base/5/t0_16390'
insert into test select generate_series(1, 1000); -- make few buffers dirty
>
> BTW, there are other bugs that can occur during interacting with other
> session temp tables. I described them and suggested corrections in
> this thread [1].
>
> [1]
> https://www.postgresql.org/message-id/flat/CAJDiXgj72Axj0d4ojKdRWG_rnkfs4uWY414NL%3D15sCvh7-9rwg%40mail.gmail.com
Sorry, thi
