On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei <catalin(at)plationline(dot)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