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
-
Restrict the use of temporary namespace in two-phase transactions
- b15160bc716e 10.7 landed
- 3e4fdb3bc0dc 11.2 landed
- c5660e0aa52d 12.0 landed