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

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: pgsql-bugs(at)postgresql(dot)org
Cc: mmitar(at)gmail(dot)com
Subject: Is temporary functions feature official/supported? Found some issues with it.
Date: 2019-01-02 17:33:12
Message-ID: 5d910e2e-0db8-ec06-dd5f-baec420513c3@imap.cc
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs

Hello,

Is creating functions in pg_temp schema something we support?
It's undocumented as far as I could see, but maybe I missed it.
People seem to use it.

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);
2) data corruption in pg_namespace, server crash (happened a few times,
but I'm not yet sure how to reproduce).

Is it something worth reporting in more detail?

Best,
  Alex

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2019-01-02 17:41:40 Re: BUG #15548: Unaccent does not remove combining diacritical characters
Previous Message Phil Hildebrand 2019-01-02 15:20:23 Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not been created yet -- apparent wraparound