Hello 2012/3/4 Alvaro Herrera <alvhe...@commandprompt.com>: > > Excerpts from Alvaro Herrera's message of sáb mar 03 17:56:23 -0300 2012: >> Excerpts from Alvaro Herrera's message of sáb mar 03 16:54:19 -0300 2012: >> > Excerpts from Pavel Stehule's message of sáb mar 03 02:25:52 -0300 2012: >> >> > > 3. THE ARE NOT CARET - this is really important >> >> > I am not sure about the caret thingy -- mainly because I don't think it >> > works all that well. > > It doesn't work correctly with your patch; see sample below. Note the > caret is pointing to an entirely nonsensical position. I'm not sure > about duplicating the libpq line-counting logic in the backend. > > Also note i18n seems to be working well, except for the "In function" > header, "query", and the error level. That seems easily fixable. > > I remain unconvinced that this is the best possible output. > > alvherre=# create function f() returns int language plpgsql as $$ > begin select > var > from > foo; end; $$; > CREATE FUNCTION > alvherre=# check function f(); > CHECK FUNCTION > --------------------------------------------------------- > In function: 'f()' > error:42P01:2:sentencia SQL:no existe la relación «foo» > query:select + > var + > from + > foo > ^ > (4 filas) >
this should be fixed. I checked expressions, that works (I expect) correctly. Caret helps - (really). Sometimes man is blind :). I'll look on this topic tomorrow and I hope this will be solvable simply. Regards Pavel > -- > Álvaro Herrera <alvhe...@commandprompt.com> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers