Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporary tables usage in functions - Mailing list pgsql-general

From Josef Šimánek
Subject Re: Temporary tables usage in functions
Date
Msg-id CAFp7Qwr-NSydrG=AkTC5Ve7=4uW4q=HVG3QSHzUw4UM7Q+fbfQ@mail.gmail.com
Whole thread Raw
In response to Temporary tables usage in functions  (Yambu <hyambu@gmail.com>)
List pgsql-general
Tree view 
po 9. 11. 2020 v 13:07 odesílatel Yambu <hyambu@gmail.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

pgsql-general by date:

Previous
From: Yambu
Date:
Subject: Temporary tables usage in functions
Next
From: Pavel Stehule
Date:
Subject: Re: Temporary tables usage in functions