Re: In PGAdmin, view compilation is running for ever

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(at)gmail(dot)com>
Sent: Friday, November 3, 2023 5:15 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: In PGAdmin, view compilation is running for ever

On 11/3/23 15:24, M Sarwar wrote:
Hello,

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.