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 ) id 1rmzJE-00AzKd-Am for pgsql-general@arkaria.postgresql.org; Wed, 20 Mar 2024 17:01:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rmzJC-006X23-Vx for pgsql-general@arkaria.postgresql.org; Wed, 20 Mar 2024 17:00:59 +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 ) id 1rmzJC-006X1o-LB for pgsql-general@lists.postgresql.org; Wed, 20 Mar 2024 17:00:59 +0000 Received: from mail-pg1-x535.google.com ([2607:f8b0:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rmzJ8-005Zxh-ML for pgsql-general@lists.postgresql.org; Wed, 20 Mar 2024 17:00:58 +0000 Received: by mail-pg1-x535.google.com with SMTP id 41be03b00d2f7-5dcc4076c13so104098a12.0 for ; Wed, 20 Mar 2024 10:00:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1710954052; x=1711558852; darn=lists.postgresql.org; h=content-transfer-encoding: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=/qm9x+QcuGjS8QQEI4Q1cts4PcSn4RvMLkRBvnptMMM=; b=inqyhp3gXXuYTb8wLQ/X3FgQ8r09JxZu4KZdlQZTXD8R6Mhg+bLRbRl0j0RiNmgq+e yL9KsrQUBL7Oa4xwjlf56nz6PaalmCFWGBZU0tuCWh6jGo+IEUQbG/eGAPx0qqdCKF1Y j5lYRlMA82welJT2gFCXLzsO/atHNWwDWUHmlJlJOgqYA79oLGvV1kLVwS4u9wlcg0+j WDycMSOETNkXa70zxdk09MpHNlywZ6TiniLODOdgJR5aZAc8kp+/ULslMO+HdwI9W1jm PebHxKtr3GFEGo1iF8zF/y15njT1/FtEZk4XI8z2AOtXWkOjGtw4pEAKWWTEPigPF/UD 7f5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1710954052; x=1711558852; h=content-transfer-encoding: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=/qm9x+QcuGjS8QQEI4Q1cts4PcSn4RvMLkRBvnptMMM=; b=LYD8twuRq8FursNT0X3j/pyhRxZ0RtrKe/HRsFb4Yqy3LBzMPrpRnpI9jTCJENSw0F YYjgwCOLztCDAPrtbwzrsHiLi2aBSV9OS4WpqQ1xiv9kSY/uENL2rNwCBc///wmr6kTW /1suCKXuFmrV0YFR21u1vNZhL6MMEDOvWKfrroBUxHPz9zk8U76YzQZzizUO8fUcw6At dgYAcaw3an7cUxH+3yvI5OsSVwN52VjzGVLHHBJPB/YDwrzAEas7Eb05Iffyi0tWtm8z x7n58z5lm/nYpwP9tPYHhqF8375sCmekn1A4cqByZo2n7iTgtio7aFpZe3b4dRxkXOdm fPBQ== X-Gm-Message-State: AOJu0YzFa9pgyWoxOS79pkuhzxWjGs8HQzRnMhsi7YDQ9dlvQnf9fIcg wkK7VwhAA4axDhjpTn4CeYK59jqctIXLRFbGqkwmIFYDdXWg//a2/34jQRp5 X-Google-Smtp-Source: AGHT+IETq+OBfz83x3XmMMdwUd3RyPaRR03+TT1Xbtc2hmnVlc726ZANPjtGqDqoYpOmf8SGJefy2g== X-Received: by 2002:a05:6a20:8428:b0:1a3:5b82:dd07 with SMTP id c40-20020a056a20842800b001a35b82dd07mr394764pzd.8.1710954052044; Wed, 20 Mar 2024 10:00:52 -0700 (PDT) Received: from ?IPV6:2601:681:5a00:f790:ec05:ca7a:ae3:e52? ([2601:681:5a00:f790:ec05:ca7a:ae3:e52]) by smtp.gmail.com with ESMTPSA id fb18-20020a056a002d9200b006e78f563f91sm1679653pfb.118.2024.03.20.10.00.51 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 20 Mar 2024 10:00:51 -0700 (PDT) Message-ID: Date: Wed, 20 Mar 2024 11:00:50 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Dropping a temporary view? Content-Language: en-CA To: pgsql-general@lists.postgresql.org References: <5b2ebf67-df3b-4b94-8a27-74d20d28f014@aklaver.com> From: Rob Sargent In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/20/24 10:51, Celia McInnis wrote: > The view is being used in some web query software that multiple people > will be accessing and the contents of the view depend on what the > person is querying, so I think that temporary views or tables are a > good idea. I change to non-temporary views or tables (in a test > version of the software which is not web-crawl-able) when I'm trying > to debug things, and I guess I have to be careful to clean those up > when I switch back to the temporary tables/views. > > Are multiple people seeing the same dataset, or is each getting their own data albeit of the same structure?  What mechanism populates the web-page?  I ask because I think you might not need to make database structures at all.