On Tue, Jul 22, 2014 at 4:36 AM, Rebecca Clarke <r.clark...@gmail.com> wrote: > Hi all, > > Presently I'm executing a function that runs many queries within it. > > select * from _myfunction(); > > Is there a way to see what query it is up to within the function? > When I do a select of pg_stat_activity it just shows me the _myfunction() > query. > > I'm running postgresql 9.1 > > Thanks in advance.
raise notices or warnings in the log. if the function is sql and not pl/pgsql, you can wrap the RAISE feature. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
