On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
