On Thu, Nov 11, 2010 at 1:51 AM, Jan Wieck <span dir="ltr"><<a href="mailto:JanWieck@yahoo.com">JanWieck@yahoo.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 11/10/2010 1:08 AM, Shoaib Mir wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
On Wed, Nov 10, 2010 at 5:01 PM, utha zoro <<a href="mailto:utha_de_hikaru@yahoo.co.id" target="_blank">utha_de_hikaru@yahoo.co.id</a><br></div><div class="im">
<mailto:<a href="mailto:utha_de_hikaru@yahoo.co.id" target="_blank">utha_de_hikaru@yahoo.co.id</a>>> wrote:<br>
<br>
<br>
<br>
what i have to do next, mr? thx<br>
<br>
<br>
Hmm well I thought you have changed the index name or something like<br>
that but doesnt look like.<br>
<br>
Have you tried doing "drop schema _ad_cluster cascade;" ??<br>
</div></blockquote>
<br>
STOP!<br>
<br>
That only works without leaving behind a corrupted system catalog in version 2.0.<br>
<br></blockquote><div><br></div><div>Yes my bad as not doing an UNINSTALL would have missed to get the tables back to unlocked state.... so I guess if hes already done the DROP SCHEMA then the solution can be:</div><div>
<br></div><div>- Re-create the database</div><div>- Restore the schema only dump from master</div><div>- Initialize the cluster (which will copy all the data across)</div><div> </div></div>-- <br>Shoaib Mir<br><a href="http://shoaibmir.wordpress.com/">http://shoaibmir.wordpress.com/</a><br>