Re: Temporary tables usage in functions

From: Josef Šimánek <josef(dot)simanek(at)gmail(dot)com>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Temporary tables usage in functions
Date: 2020-11-09 12:18:04
Message-ID: CAFp7Qwr-NSydrG=AkTC5Ve7=4uW4q=HVG3QSHzUw4UM7Q+fbfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

po 9. 11. 2020 v 13:07 odesílatel Yambu <hyambu(at)gmail(dot)com> napsal:
>
> Hi
>
> May I know if a temporary table is dropped at the end of a function?

Check https://www.postgresql.org/docs/12/sql-createtable.html#SQL-CREATETABLE-TEMPORARY,
especially the "ON COMMIT" part.

>
> Also may I know if excessive use of temporary tables may cause locks?
>
> regards

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2020-11-09 12:52:40 Re: Temporary tables usage in functions
Previous Message Yambu 2020-11-09 12:07:25 Temporary tables usage in functions