On Thu, May 8, 2014 at 10:52 PM, Walter Hurry <walterhu...@gmail.com> wrote:
> On Thu, 08 May 2014 13:15:54 +0300, Constantine Yannakopoulos wrote: > most if not all other databases do not implement this > > $ psql > psql (9.3.4) > Type "help" for help. > <snip> > > I meant that they do not implement a way to *directly* get attributes of the error like table name, constraint name, record key etc. e.g. by means of api functions. Or if some do I haven't found the way. All databases include this information in the error message, and in such a way that it is easily extractable by text parsing, e.g. using a regexp with groups. And as you see, postgresql also quotes the names to make parsing easy, which is what I've asked for. I've used such an approach with both MSSQL and Oracle with success. --Constantine _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
