From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Petr Jelínek <pjmodos(at)pjmodos(dot)net>, Greg Smith <greg(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Subject: | Re: review: CHECK FUNCTION statement |
Date: | 2012-03-03 23:13:04 |
Message-ID: | 1330816012-sup-8375@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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)
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2012-03-04 01:20:01 | Re: archive_keepalive_command |
Previous Message | Jeff Janes | 2012-03-03 21:15:59 | Re: Memory usage during sorting |