On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei <cata...@plationline.eu> wrote: > when I recreate a VIEW or FUNCTION with a small change I get: > > Query returned successfully with no result in 03:58 minutes.
This is almost certainly due to locks. Next time this happens, query pg_stat_activity and pg_locks -- the information is there to determine if you are locked and who the locker is. Your view creating query would be blocked as 'waiting' if that's the case. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
