pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Dropping a temporary view?
Date: Wed, 20 Mar 2024 11:00:50 -0600
Message-ID: <cffd5e55-2805-4371-a111-be05966fc8f8@gmail.com> (raw)
In-Reply-To: <CAGD6t7+vGjFj=VYWDsnwFg=7j13xEnceJ11aRBvHQis5QdHrpQ@mail.gmail.com>
References: <CAGD6t7JniiFU5_tu=1Dpa1-E_HjVdWyT8T7RaU6uTZ-7WF9TiQ@mail.gmail.com>
	<p3bniwsob54rr2y436hhjkl6c44k3refzzyjeqmh365fig726a@qq6ht7hzh4j6>
	<CAGD6t7+xR3YpP3QurENxL1p1FAv8zohd_8cg=tNRX10NZGHQZA@mail.gmail.com>
	<5b2ebf67-df3b-4b94-8a27-74d20d28f014@aklaver.com>
	<CAGD6t7+vGjFj=VYWDsnwFg=7j13xEnceJ11aRBvHQis5QdHrpQ@mail.gmail.com>



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.






view thread (16+ messages)  latest in thread

Message-ID: <cffd5e55-2805-4371-a111-be05966fc8f8@gmail.com>
Permalink:  ../cffd5e55-2805-4371-a111-be05966fc8f8@gmail.com/
Also on:    postgresql.org/message-id/cffd5e55-2805-4371-a111-be05966fc8f8@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: robjsargent@gmail.com
  Subject: Re: Dropping a temporary view?
  In-Reply-To: <cffd5e55-2805-4371-a111-be05966fc8f8@gmail.com>
  References: <CAGD6t7JniiFU5_tu=1Dpa1-E_HjVdWyT8T7RaU6uTZ-7WF9TiQ@mail.gmail.com> <p3bniwsob54rr2y436hhjkl6c44k3refzzyjeqmh365fig726a@qq6ht7hzh4j6> <CAGD6t7+xR3YpP3QurENxL1p1FAv8zohd_8cg=tNRX10NZGHQZA@mail.gmail.com> <5b2ebf67-df3b-4b94-8a27-74d20d28f014@aklaver.com> <CAGD6t7+vGjFj=VYWDsnwFg=7j13xEnceJ11aRBvHQis5QdHrpQ@mail.gmail.com> <cffd5e55-2805-4371-a111-be05966fc8f8@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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