pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIn PGAdmin, view compilation is running for ever
3+ messages / 2 participants
[nested] [flat]
* In PGAdmin, view compilation is running for ever
@ 2023-11-03 20:24 M Sarwar <sarwarmd02@outlook.com>
0 siblings, 1 reply; 3+ messages in thread
From: M Sarwar @ 2023-11-03 20:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hello,
I am trying to compile the attached view using pgadmin. It is running forever without giving any error.
Thanks,
Sarwar
Attachments:
[application/octet-stream] salesforce-vw_tab_dies-1.SQL (2.1K, ../../DM4PR19MB5978123F0BC6BF9396D87A2ED3A5A@DM4PR19MB5978.namprd19.prod.outlook.com/3-salesforce-vw_tab_dies-1.SQL)
download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: In PGAdmin, view compilation is running for ever
@ 2023-11-03 21:15 Ron <ronljohnsonjr@gmail.com>
parent: M Sarwar <sarwarmd02@outlook.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ron @ 2023-11-03 21:15 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: In PGAdmin, view compilation is running for ever
@ 2023-11-03 23:07 M Sarwar <sarwarmd02@outlook.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: M Sarwar @ 2023-11-03 23:07 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-11-03 23:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-03 20:24 In PGAdmin, view compilation is running for ever M Sarwar <sarwarmd02@outlook.com>
2023-11-03 21:15 ` Ron <ronljohnsonjr@gmail.com>
2023-11-03 23:07 ` M Sarwar <sarwarmd02@outlook.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox