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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
Cc: pgsql-bugs(at)postgresql(dot)org, mmitar(at)gmail(dot)com
Subject: Re: Is temporary functions feature official/supported? Found some issues with it.
Date: 2019-01-02 19:22:29
Message-ID: 22938.1546456949@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alexey Bashtanov <bashtanov(at)imap(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-01-02 19:32:32 Re: BUG #15548: Unaccent does not remove combining diacritical characters
Previous Message Hugh Ranalli 2019-01-02 17:58:03 Re: BUG #15548: Unaccent does not remove combining diacritical characters