po 9. 11. 2020 v 13:07 odesílatel Yambu <hya...@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
