<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">I think you want { key => ‘primary’ }. In this case the key is the name of the constraint (‘primary’ for the primary key), not the column</div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">On Aug 21, 2017, at 9:45 AM, Rajeev Prasad <<a href="mailto:rp.neuli@yahoo.com" class="">rp.neuli@yahoo.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><div style="background-color: rgb(255, 255, 255); font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;" class="">no, nodeID is auto increment field as seen in tabel description. it is complaining there is no such key. i dont know why...<br class=""><div id="yui_3_16_0_ym19_1_1503322935090_7807" class=""><span class=""></span></div> <div class="qtdSeparateBR"><br class=""><br class=""></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;" class=""> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" class=""> <div dir="ltr" class=""><font face="Arial" size="2" class=""> On Monday, August 21, 2017 7:39 AM, tirveni yadav <<a href="mailto:yadav.tirveni@gmail.com" class="">yadav.tirveni@gmail.com</a>> wrote:<br class=""></font></div> <br class=""><br class=""> <div class="y_msg_container"><div dir="ltr" class="">On Mon, Aug 21, 2017 at 6:50 AM, Rajeev Prasad <<a shape="rect" ymailto="mailto:rp.neuli@yahoo.com" href="mailto:rp.neuli@yahoo.com" class="">rp.neuli@yahoo.com</a>> wrote:<br clear="none" class="">><br clear="none" class="">> why am i getting this err in DBIx::Class ?<br clear="none" class="">><br clear="none" class="">> $./update_db.pl<br clear="none" class="">> DBIx::Class::ResultSource::unique_constraint_columns(): Unknown unique<br clear="none" class="">> constraint nodeid on 'node' at ./update_from_ieds.pl line 80<br clear="none" class="">><br clear="none" class="">><br clear="none" class="">> relevant code:<br clear="none" class="">> ...<br clear="none" class="">> sub addNode<br clear="none" class="">> {<br clear="none" class="">> my $node = shift; my $lcNode = lc($node);<br clear="none" class="">> my $id = $schema<br clear="none" class="">> ->resultset('Node')<br clear="none" class="">> ->find_or_create<br clear="none" class="">> (<br clear="none" class="">> { nodeName => $lcNode },<br clear="none" class="">> { key => 'nodeid' }<br clear="none" class="">> );<br clear="none" class="">> return $id;<br clear="none" class="">> }<br clear="none" class=""><br clear="none" class=""><br clear="none" class="">Are you trying to do this:<div class="yqt9850060855" id="yqtfd19851"><br clear="none" class=""><br clear="none" class="">my $id = $schema<br clear="none" class=""> ->resultset('Node')->find_or_create<br clear="none" class=""> (<br clear="none" class=""> {<br clear="none" class=""> nodeName => $lcNode ,</div><br clear="none" class=""> nodeID => $nodeid,<br clear="none" class=""> }<br clear="none" class=""> );<br clear="none" class=""><br clear="none" class=""><br clear="none" class="">-- <br clear="none" class="">Regards,<br clear="none" class=""><br clear="none" class="">Tirveni Yadav<br clear="none" class=""><br clear="none" class=""><a href="http://www.bael.io" class="">www.bael.io</a><br clear="none" class=""><br clear="none" class="">What is this Universe ? From what it arises ? Into what does it go?<br clear="none" class="">In freedom it arises, In freedom it rests and into freedom it melts away.<br clear="none" class="">Upanishads.<div class="yqt9850060855" id="yqtfd82939"><br clear="none" class=""></div></div><br class=""><br class=""></div> </div> </div> </div></div></div>_______________________________________________<br class="">List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" class="">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br class="">IRC: <a href="http://irc.perl.org" class="">irc.perl.org</a>#dbix-class<br class="">SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" class="">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br class="">Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" class="">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a></div></blockquote></div><br class=""></body></html>