Search Postgresql Archives

Re: Empty materialized view

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 3/24/24 13:11, Thiemo Kellner wrote:


Am 24.03.2024 um 20:56 schrieb Erik Wienhold:
Maybe you executed REFRESH in a transaction but did not commit it?

While I can see the point for the refresh (but there actually is a commit), I cannot hold it valid for a create with data when the mv actually is created (confirmed by being empty).

Confirmed in the same session that created it or in a different session?


I can't find any materialized view in your archive.

Oh sh*. That is the file, I forgot to commit. Please find it attached now.

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux