<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<div style="font-family: Tahoma; font-size: 10pt; ">Hi, </div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div><font class="Apple-style-span" face="Tahoma" size="2">I'm trying to change the datasource of a postgis layer created with RT SQL, I mean, I want to make changes in the query after the layer is created. </font></div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div>I tried this:</div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><span id="internal-source-marker_0.4605584149248898" style="font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; "><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><span id="internal-source-marker_0.4605584149248898" style="font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">l=qgis.utils.iface.activeLayer()</span><br><span style="font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">d=l.dataProvider()</span></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; font-family: 'Times New Roman'; white-space: normal; font-size: 12pt; "><span id="internal-source-marker_0.4605584149248898" style="font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">d.setDataSourceUri(</span><span class="Apple-style-span" style="font-family: Arial; font-size: 15px; white-space: pre-wrap; ">u'dbname=\'postgis\' host.......') </span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; font-family: 'Times New Roman'; white-space: normal; font-size: 12pt; "><span class="Apple-style-span" style="font-family: Arial; font-size: 15px; white-space: pre-wrap; ">l.reload()</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; font-family: 'Times New Roman'; white-space: normal; font-size: 12pt; "><span class="Apple-style-span" style="font-family: Arial; font-size: 15px; white-space: pre-wrap; "><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><span class="Apple-style-span" style="font-family: Arial; font-size: 15px; white-space: pre-wrap; ">It's ok, but nothing happens.</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><span class="Apple-style-span" style="font-family: Arial; font-size: 15px; white-space: pre-wrap; ">Am I in the right path? What am I missing?</span></div></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="font-size: 15px; white-space: pre-wrap;"><br></span></font></div><br><font class="Apple-style-span" face="Tahoma" size="2">Pablo Torres Carreira
</font><br><br> </body>
</html>