Re: Is temporary functions feature official/supported? Found some issues with it.

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexey Bashtanov <bashtanov@imap.cc>
Cc: pgsql-bugs@postgresql.org, mmitar@gmail.com
Date: 2019-01-02T19:22:29Z
Lists: pgsql-bugs
Alexey Bashtanov <bashtanov@imap.cc> writes:
> Is creating functions in pg_temp schema something we support?

Yeah.

> I found that a combination of temporary functions and prepared 
> transactions can lead to:
> 1) all other sessions being unable to create a temporary table until the 
> prepared transaction is finished (reproducible);

Locking issue perhaps?  It's not a bug if a prepared transaction
is holding a lock.

> 2) data corruption in pg_namespace, server crash (happened a few times, 
> but I'm not yet sure how to reproduce).

That would be interesting.

			regards, tom lane


Commits

  1. Restrict the use of temporary namespace in two-phase transactions