"Tom Lane" <tgl@sss.pgh.pa.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!