<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hi Qi,
<div class=""><br class="">
</div>
<div class="">my guess is that you just have a partially created omero database from your previous attempts, that's why the sql script fails.</div>
<div class="">Could you delete the omero database and create a new empty one, and then run the OMERO5.2___0.sql script again?</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class="">Dominik</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On 8 Mar 2017, at 21:33, Qi Gong <<a href="mailto:qigong@gwmail.gwu.edu" class="">qigong@gwmail.gwu.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Hello Dominik,
<div class=""><br class="">
</div>
<div class="">Thank you for your reply. You are correct. After I set "owner" and "can login", I can log in from psql. </div>
<div class=""><br class="">
</div>
<div class="">When I first type <span style="background-color: rgb(241, 241, 241); font-family: consolas, 'deja vu sans mono', 'bitstream vera sans mono', monospace; font-size: 14px; letter-spacing: 0.015em;" class="">\i C:/OMERO.server/OMERO5.2__0.sql</span> command.
It gives me feedback as first attachment(" alter table" ...). But I click "x" but not type "\q" to quit. </div>
<div class="">I open the psql again and type <span style="background-color: rgb(241, 241, 241); font-family: consolas, 'deja vu sans mono', 'bitstream vera sans mono', monospace; font-size: 14px; letter-spacing: 0.21px;" class="">\i C:/OMERO.server/OMERO5.2__0.sql</span> command.
It gives me transaction error. </div>
<div class=""><br class="">
</div>
<div class="">In cmd window, there is still diagnostics problem. I think it might due to psql.</div>
<div class=""><br class="">
</div>
<div class="">Thank you very much again.</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class="">Qi</div>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
<br>
<span style="font-size:10pt;">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</body>
</html>