Dear Tom, > > Please find attached my first attempt at providing a localisation > > information on the client side for syntax errors in "psql". > > "Localisation" tends to mean something quite different around here. I'd > suggest renaming the function to something like ReportSyntaxErrorPosition.
Ok. "Localisation" was the good french word;-) > Would it read better to add "..." at the front and/or back of the query > extract, when you have actually truncated text at that end? I thought about it as well, but did not implement it. I agree that it would look better. I can have a go. > The "on line N" bit seems just noise to me. It depends. If you're in the middle of a sql-script as I often do, giving the line within the statement isn't bad. Say: SELECT o.titre FROM collections AS col, ouvrages AS o, a_ecrit AS e, auteurs AS a WHERE o.id=e.oeuvre AND e.auteur=a.id AND o.collection=col.id AND col.nom LIKE '%Spirou%' AND a.nom<>'Franquin' EXCEPT SELECT o.titre FROM collections AS col, ouvrages AS o, a_ecrit AS e, auteurs AS a WHERE o.id=e.oeuvre AND e.auteur=a.id AND o.collection=col.id AND col.nom LIKE '%Spirou%' AND a.nom='Franquin'; All lines look the same... So I would prefer to keep it. Well, if it is the only issue against the adoption of the patch, I will do without the line number. I'll submit a new patch in a moment. Thanks for your comments, -- Fabien. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly