Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qz1WS-00Cq9i-LT
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 Nov 2023 21:16:08 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qz1WQ-003Ph2-M4
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 Nov 2023 21:16:06 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qz1WQ-003Pgu-Av
	for pgsql-admin@lists.postgresql.org; Fri, 03 Nov 2023 21:16:06 +0000
Received: from mail-yw1-x1136.google.com ([2607:f8b0:4864:20::1136])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qz1WN-004YcQ-Vb
	for pgsql-admin@lists.postgresql.org; Fri, 03 Nov 2023 21:16:05 +0000
Received: by mail-yw1-x1136.google.com with SMTP id
 00721157ae682-5a82c2eb50cso30302237b3.2
        for <pgsql-admin@lists.postgresql.org>;
 Fri, 03 Nov 2023 14:16:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1699046160; x=1699650960;
 darn=lists.postgresql.org;
        h=in-reply-to:from:references:to:content-language:subject:user-agent
         :mime-version:date:message-id:from:to:cc:subject:date:message-id
         :reply-to;
        bh=Duh5TepXE3zwmZelgJ9BJESGbexwEJjLehHJnPUO0iw=;
        b=FmsnbVP3crILKkudX4cDAn8Q8wBdrmS9qGL/tc7tvPVq0l71sllHT/zZ5TtQe/wGYK
         X5fMUmV56zqIkcqHv3RHnLHHs14NOuIQYoXJFKIoUcyW6R9T89LOa2nFv7sLuSLD7vm8
         crYGWSXcNl0wWwEg0Pj3gAEAVv6H9n3wZdRR7MkXbLRF3tvEdKsXtAafnS4NxDmkJPHb
         XONhde3FA8/7pCS2LL/coaKj5tL0xa8sf6rN8jB7txgAcHb962mpNnP6EF8n9L86bA5k
         /P3TyElGEbU+Q47Lbn+/YvJnj3p0Or/hZ527OGaQXrSg7sRh6gvFoa7FhbK7UDGEGVE4
         rGQA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1699046160; x=1699650960;
        h=in-reply-to:from:references:to:content-language:subject:user-agent
         :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject
         :date:message-id:reply-to;
        bh=Duh5TepXE3zwmZelgJ9BJESGbexwEJjLehHJnPUO0iw=;
        b=LbrWOJF0H1iwrY01kR4zkmEgO8HQWQNadz35YLSoLfRsa16XN2jYBxE9/VncDSL2MR
         MzRpXbmntmqYXeZYMVLzLf9sQPh3WDiCm0fGKYC+Ch2vOahjxF8CiPMFXnmtx/O+G/IV
         mW6XeOxx7ATBYTztNURZ5M3LoXUI2f7559ZZkDXJOgBmaUf2Yu15LmrdCQTS2aICsxa7
         Az2uM235CyoECSX447PK0CR+UiLOPLgYfcn6Qy6sJLVTli54LcjKr0oU0MX924rH7KhX
         xYQVifzGiRUdQiVHoVnUan/4MP0Y7IZlR9Ok59FQ3KPmbPA1heVz6b0rD/s2m70rBoTI
         rKPA==
X-Gm-Message-State: AOJu0YzAG7G87zCZStyFWqpbQ8fcfU8T0SuU3Dfj4m/NuV26vV0ma1id
	bcZURKM4x8mVIKAyzwwkIJmxwy/Lvh8=
X-Google-Smtp-Source: 
 AGHT+IGTHwNdMkO51gyqzAG8uWzmSHDNInCyCjHuGyYnaXwT1cJ7axcQBoKTTopPmemNWhgFvsewaw==
X-Received: by 2002:a81:4950:0:b0:5a7:c72b:812 with SMTP id
 w77-20020a814950000000b005a7c72b0812mr3948296ywa.17.1699046159797;
        Fri, 03 Nov 2023 14:15:59 -0700 (PDT)
Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44])
        by smtp.googlemail.com with ESMTPSA id
 y130-20020a81a188000000b005925c896bc3sm1415575ywg.53.2023.11.03.14.15.59
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Fri, 03 Nov 2023 14:15:59 -0700 (PDT)
Content-Type: multipart/alternative;
 boundary="------------Hq6x5byuAH6W39fYOGE3XMY4"
Message-ID: <7c819119-c64a-4efe-8d88-adf8e84682cd@gmail.com>
Date: Fri, 3 Nov 2023 16:15:59 -0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: In PGAdmin, view compilation is running for ever
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <PH2P110MB0922155B6BFB0D6327CD2604FFA5A@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
 <DM4PR19MB5978123F0BC6BF9396D87A2ED3A5A@DM4PR19MB5978.namprd19.prod.outlook.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <DM4PR19MB5978123F0BC6BF9396D87A2ED3A5A@DM4PR19MB5978.namprd19.prod.outlook.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/7c819119-c64a-4efe-8d88-adf8e84682cd%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Hq6x5byuAH6W39fYOGE3XMY4
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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.
--------------Hq6x5byuAH6W39fYOGE3XMY4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 11/3/23 15:24, M Sarwar wrote:<br>
    <blockquote type="cite"
cite="mid:DM4PR19MB5978123F0BC6BF9396D87A2ED3A5A@DM4PR19MB5978.namprd19.prod.outlook.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
      <div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"
        class="elementToProof">
        <span style="">Hello,</span></div>
      <div
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"
        class="elementToProof">
        <span style=""> </span><br>
      </div>
      <div style="word-wrap:break-word" lang="EN-US">
        <div class="x_WordSection1">
          <p class="x_MsoNormal"
style="margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
            I am trying to compile the attached view using pgadmin. It
            is running forever without giving any error.</p>
        </div>
      </div>
    </blockquote>
    <br>
    If you're just trying to run that script, and it's hanging, then
    it's blocked by some other process.<br>
    <br>
    <div class="moz-signature">-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </body>
</html>

--------------Hq6x5byuAH6W39fYOGE3XMY4--