Re: views, queries, and locks - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: views, queries, and locks
Date
Msg-id jlfd61$o7s$1@dough.gmane.org
Whole thread Raw
In response to views, queries, and locks  (Jon Nelson <jnelson+pgsql@jamponi.net>)
List pgsql-general
Jon Nelson wrote on 03.04.2012 19:01:
> I also update this view with CREATE OR REPLACE VIEW every 15-30 minutes

That is a highly questionable approach.

What real problem are you trying to solve with that?
Maybe there is a better solution that does not require changing the view.



pgsql-general by date:

Previous
From: Jon Nelson
Date:
Subject: Re: views, queries, and locks
Next
From: leaf_yxj
Date:
Subject: Re: Please help me to take a look of the erros in my functions. Thanks.