Search Postgresql Archives

Re: postgres 9.6: insert into select finishes only in pgadmin not psql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux