<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br><div><div>On Mar 30, 2014, at 5:29 AM, Johnny Harris <<a href="mailto:johnny@southshore.com">johnny@southshore.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div style="font-size: 12pt; font-family: Calibri;">
<div style="FONT-FAMILY: ; COLOR: ">
<div>Greeting Everyone,</div>
<div> </div>
<div>1. I’m getting an error when I try to update a table record using
SQL.</div>
<div> </div>
<div>Error: Primary key constraint violation occurred, table name =
“support_payments”, constraint name = “PK_support_payments_pk”.</div>
<div> </div>
<div>I don’t get this error every time I try to update a record. Just
occasionally. I’m not trying to update the primary key field, so I’m not
really</div>
<div>sure why I’m receiving this error.</div>
<div> </div>
<div> </div></div></div></div></div></blockquote><div><br></div>I will check this once more. But we are speaking about this field <span style="font-family: Calibri; font-size: 12pt;">pk SERIAL64 PRIMARY KEY ?</span></div><div><span style="font-family: Calibri; font-size: 12pt;"><br></span></div><div><br><blockquote type="cite"><div dir="ltr"><div dir="ltr"><div style="font-size: 12pt; font-family: Calibri;"><div style="FONT-FAMILY: ; COLOR: ">
<div> </div>
<div>2. When I create a table in code, the fields I define as BOOLEAN are
Indexed by default. I don’t need the fields indexed.</div>
<div> </div>
</div></div></div></div></blockquote></div><div><br></div>Actually, "automatic" indexed flag for boolean field costs nothing to you due to the specific implementation.<div>Why do you need to have it not-indexed?</div><div><span style="orphans: 2; text-align: -webkit-auto; widows: 2;"><br></span></div><div><span style="orphans: 2; text-align: -webkit-auto; widows: 2;">-- </span><br><div><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><div>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div></span>
</div>
<br></div></div></body></html>