Re: Different results from identical matviews

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Anders Steinlein <anders(at)e5r(dot)no>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Different results from identical matviews
Date: 2020-07-02 12:55:18
Message-ID: CAHOFxGp_yXW4+y-6L_6+18OjPzxe2wb6ua0hFVOKnbnYJpJtqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is now() computed at the time the view is defined and not at refresh? If
this were a function, I would be more suspicious of that but a plain view,
surely not. I hope.

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Smith 2020-07-02 13:01:02 Re: Different results from identical matviews
Previous Message Brajendra Pratap Singh 2020-07-02 11:37:15 Check Replication lag status