<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><span></span></div><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><div></div><div><br></div><div>Hey Federico,</div><div><br></div><div>Am 19.10.2017 um 21:00 schrieb <a href="mailto:geonode-users-request@lists.osgeo.org">geonode-users-request@lists.osgeo.org</a>:<br><br></div><blockquote type="cite"><div>So I should manage the base_resourcebase table, where is it located? </div></blockquote><br><div>It s a table in your postgres Database. </div><div>You can Update it with something like:</div><div><pre class="lang-sql prettyprint prettyprinted" style="margin-top: 0px; padding: 5px; border: 0px; line-height: inherit; vertical-align: baseline; width: auto; max-height: 600px; overflow: auto; word-wrap: normal;"><code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline; white-space: normal; background-color: rgba(255, 255, 255, 0);"><font face="UICTFontTextStyleTallBody"><span class="kwd" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">UPDATE</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;"> base_resourcebase </span><span class="kwd" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">SET</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;"> owner_id</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;"> </span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">=</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;"> replace</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">(owner_id</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;"> </span><span class="str" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">'old_id'</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">,</span><span class="pln" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;"> </span><span class="str" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">'new_id'</span><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">)</span></font></code></pre><pre class="lang-sql prettyprint prettyprinted" style="margin-top: 0px; padding: 5px; border: 0px; line-height: inherit; vertical-align: baseline; width: auto; max-height: 600px; overflow: auto; word-wrap: normal;"><font face="UICTFontTextStyleTallBody"><span style="white-space: normal;">Haven t checked if owner_id is the correct name. Have a look at the table or the resource_base Model to double check it. </span></font></pre><pre class="lang-sql prettyprint prettyprinted" style="margin-top: 0px; padding: 5px; border: 0px; line-height: inherit; vertical-align: baseline; width: auto; max-height: 600px; overflow: auto; word-wrap: normal;"><code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline; white-space: normal; background-color: rgba(255, 255, 255, 0);"><font face="UICTFontTextStyleTallBody"><span class="pun" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant-caps: inherit; line-height: inherit; vertical-align: baseline;">Cheers toni</span></font></code></pre></div></div></body></html>