Hi,
I have a pl/pgSQL function[1] to calculate row numbers (based on [2]).
It uses a custom variable. This was working earlier, but is breaking now
saying it can't recognise the variable. The custom_variable_classes is
set in the postgresql.conf.
pgdb001=> select rownum('') from generate_ser
Taras Kopets wrote:
now you have to initialize this variable once per session before usage:
SELECT set_config('olap.rownum_name', false);
Ok, thanks. That has fixed my problem.
Malcolm
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
