On 9/23/19 12:07 AM, Corey Taylor wrote:
> First thing I'd look at is whether it's the same execution environment
> in both cases, eg same search_path.
>
>
> As far as I can tell, it's the same execution environment, same
> search_path and same user.
>
> I found after testing other situations, that the psql command would
> always finish as expected after canceling the first query that ran too
> long. I was able to reproduce this scenario with psql and pgadmin4 with
> various combinations.
>
> Any suggestions on what that would indicate? The canceled query does
> not complete as there are no rows and no duplicate errors when running
> the second time.
Can we see the actual function/query?
Also the schema of the table(s) involved?
>
> corey
--
Adrian Klaver
adrian.klaver@aklaver.com
