From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: a07f3367d7,d654f990612c5da5 X-Google-Attributes: gida07f3367d7,public,usenet X-Google-NewGroupId: yes X-Google-Language: ENGLISH,ASCII-7-bit Received: by 10.180.82.226 with SMTP id l2mr5146249wiy.1.1346980966912; Thu, 06 Sep 2012 18:22:46 -0700 (PDT) Path: q11ni5513255wiw.1!nntp.google.com!feeder3.cambriumusenet.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!85.12.40.139.MISMATCH!xlned.com!feeder7.xlned.com!multikabel.net!newsfeed10.multikabel.net!feed.xsnews.nl!border-1.ams.xsnews.nl!border4.nntp.ams.giganews.com!border2.nntp.ams.giganews.com!nntp.giganews.com!newsreader4.netcologne.de!news.netcologne.de!news.enother.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!post02.iad.highwinds-media.com!news.flashnewsgroups.com-b7.4zTQh5tI3A!not-for-mail From: Stephen Leake Newsgroups: comp.lang.ada Subject: Re: GNATCOLL SQLite rollback vs cursor References: <85ipbzwdsc.fsf@stephe-leake.org> Date: Sat, 01 Sep 2012 12:31:13 -0400 Message-ID: <85627xwvqm.fsf@stephe-leake.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.1 (windows-nt) Cancel-Lock: sha1:7OSLQUJpL1WnnsispX8BzL8cVko= MIME-Version: 1.0 X-Complaints-To: abuse@flashnewsgroups.com Organization: FlashNewsgroups.com X-Trace: 89dd850423855e029e66123443 X-Received-Bytes: 1457 Content-Type: text/plain Date: 2012-09-01T12:31:13-04:00 List-Id: briot.emmanuel@gmail.com writes: > It is quite possible that this issue has in fact already been fixed in > the development version of GNATCOLL, because now with or without the > line that frees the cursor, the result is the same: > > Insert Ada Lovelace > ID => 1 > Insert Charles Babbage > ID => 2 > Insert Ada Lovelace > [SQL.ERROR] Failed to execute INSERT INTO Author (First, Last) VALUES > ("Ada", "Lovelace") error=columns First, Last are not unique > ID => 1 > Insert Grace Hopper > ID => 3 > > > Note also that we have improved the way we retrieve the error messages > from sqlite, since the current one is clearer than just the > "constraint error" you are getting. Excellent. -- -- Stephe