Home > mailing lists

calling function - Mailing list pgsql-sql

From	Yambu
Subject	calling function
Date	December 3, 2020 06:47:21
Msg-id	CALhHtcBy8Y3sTYhp0D9Neu7MDQuxPQLvEcXmQDESXGPiqD_geQ@mail.gmail.com Whole thread Raw
List	pgsql-sql

Hello

What are the caveats in calling function like this

select * from myfun()

if myfunc() returns a composite type and has inserts inside.

We are experiencing many locks

regards

From: Tom Lane
Date: 02 December 2020, 19:15:35
Subject: Re: parallel safe on user defined functions

From: Anders Svensson
Date: 03 December 2020, 12:52:56
Subject: Re: Join push down on FDW partitions