Re: logger: NOTICE: Unrecognized variable query_limit - Mailing list pgsql-general

"Havrylyak Roma" <roma@ukr.net> writes:
> Does anybody know how to fix error (see subject)? I suppose the problem is
> in using PSQL (may be old version) but direct SQL command SET QUERY_LIMIT is
> not using...

Your application must have been coded against Postgres 6.4 originally
--- that was the only release that had a query_limit variable.  Since
6.5 we instead offer a LIMIT clause in SELECT.  You'll need to revise
the application code to use SELECT...LIMIT instead of SET QUERY_LIMIT.

            regards, tom lane