"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> I was somewhat bemused just now to find that this function stopped
> working:
>
> regression=# create function estimate_rows(query text) returns float8 as $$
...
> This works fine in 8.2. The reason it no longer works is that "query"
> is now a special token in the plpgsql lexer, and that means that it will
> never be substituted for by read_sql_construct(). So it's effectively
> a reserved word.
Perhaps we should be throwing a more intelligible error if you have a
parameter (or variable?) named in a way that will conflict?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!