Re: In PGAdmin, view compilation is running for ever
| От | M Sarwar |
|---|---|
| Тема | Re: In PGAdmin, view compilation is running for ever |
| Дата | |
| Msg-id | DM4PR19MB59781B085AED168E8BA4D291D3A5A@DM4PR19MB5978.namprd19.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: In PGAdmin, view compilation is running for ever (Ron <ronljohnsonjr@gmail.com>) |
| Список | pgsql-admin |
Hi Ron,
After running for more than 90 minutes, I got the below message.
ERROR: relation "salesforce.vw_tab_wafers" does not exist LINE 23: FROM salesforce.vw_tab_wafers w ^ SQL state: 42P01 Character: 1512
I do not know why it took so much time.
I appreciate your response.
Once I fixed the view as per the message, it went fine.
Sarwar
From: Ron <ronljohnsonjr@gmail.com>
Sent: Friday, November 3, 2023 5:15 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: In PGAdmin, view compilation is running for ever
Sent: Friday, November 3, 2023 5:15 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: In PGAdmin, view compilation is running for ever
On 11/3/23 15:24, M Sarwar wrote:
If you're just trying to run that script, and it's hanging, then it's blocked by some other process.
I am trying to compile the attached view using pgadmin. It is running forever without giving any error.
If you're just trying to run that script, and it's hanging, then it's blocked by some other process.
--
Born in Arizona, moved to Babylonia.
Born in Arizona, moved to Babylonia.
В списке pgsql-admin по дате отправления: