Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
| От | Adrian Klaver |
|---|---|
| Тема | Re: postgres 9.6: insert into select finishes only in pgadmin notpsql |
| Дата | |
| Msg-id | d4e25e56-3388-0684-d0b8-762b3ac6e700@aklaver.com обсуждение исходный текст |
| Ответ на | Re: postgres 9.6: insert into select finishes only in pgadmin not psql (Corey Taylor <corey.taylor.fl@gmail.com>) |
| Ответы |
Re: postgres 9.6: insert into select finishes only in pgadmin not psql
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: