<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi again,</p>
<p>i see
(<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/29437650/how-can-i-ensure-that-a-materialized-view-is-always-up-to-date">https://stackoverflow.com/questions/29437650/how-can-i-ensure-that-a-materialized-view-is-always-up-to-date</a>)
i can do it with an external program pgsidekick which catch notify
: <a class="moz-txt-link-freetext" href="https://github.com/wttw/pgsidekick">https://github.com/wttw/pgsidekick</a> .</p>
<p>It's the first time i try to install a program and when i wrote
make , the program don't find pg_config and libpq-fe.h : <br>
</p>
<p><img src="cid:part1.EA3CBCB9.8CDD28D8@ledepartement82.fr" alt=""></p>
<p>I try with no attributes, with -I /usr/pgsql-9.5/include/ and
with -I /usr/pgsql-9.5/ . none of them works.</p>
<p>pg_config is in /usr/pgsql-9.5/bin
</p>
<p>libpq-fe.h is in /usr/pgsql-9.5/include</p>
<p>Thanks for your help<br>
</p>
<div class="moz-signature">
<table width="450" height="100" cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr valign="bottom">
<td colspan="2">
<hr size="3" noshade="noshade" color="#CCCCCC"> </td>
<td>
<br>
</td>
</tr>
<tr>
<td>
<a href="http://www.ledepartement.fr" hreflang="fr">
<img
src="http://www.ledepartement.fr/fileadmin/integration/lib/images/logo-cd82-footer.png
" alt="Logo CD82" width="150" border="0" align="left">
</a> </td>
<td>
<font size="3" face="Eras Medium ITC">
Guillaume ARNAUD
</font><br>
<font size="2" face="Eras Medium ITC">
Technicien SIG
</font><br>
<font medium="" itc»="" size="»2»" face="»Eras">
Cellule SIGD
</font><br>
<font medium="" itc»="" size="»2»" face="»Eras">
Direction des systèmes informatiques et de
télécommunication
</font><br>
<font medium="" itc»="" size="»2»" face="»Eras">
Pôle coordination et ressources
</font><br>
<font size="2" face="Eras Medium ITC">Tél : 05 63 91 82 37
</font><br>
<a class="moz-txt-link-freetext" href="mailto:
guillaume.arnaud@ledepartement82.fr
"><font size="2">
guillaume.arnaud@ledepartement82.fr
<!--
font--></font></a><font size="2">
</font></td>
</tr>
<tr valign="top">
<td colspan="2">
<hr size="3" noshade="noshade" color="#CCCCCC">
</td>
</tr>
</tbody>
</table>
</div>
<div class="moz-cite-prefix">Le 01/04/2020 à 18:12, J.J. Green a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:acfaa72c-840d-1d91-95d6-fdac345410f6@gmx.com">Hi
Guillaume
<br>
<br>
> Hello, I need to refresh a materialized view in my database,
<br>
<br>
I've faced similar problems with complex derived data being too
<br>
much for a view and finding the lack of incremental update on
<br>
the standard PG materialised views means I could only update very
<br>
occasionally.
<br>
<br>
In the end, I managed to get a working solution with a "manually
<br>
materialised view", so this is just a regular table, and I have
<br>
triggers which wait for new data, and when they run they insert
<br>
the new suitably modified rows into that table.
<br>
<br>
This is _not easy_, there are lots of gotchas and edge-cases,
<br>
for my case the underlying problem was not too hard, it was just
<br>
that underlying data was too damn big.
<br>
<br>
The code was commercial, so I'm afraid I can't post it.
<br>
<br>
Bon chance !
<br>
<br>
Jim
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote>
</body>
</html>