Thread: logger: NOTICE: Unrecognized variable query_limit
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... Roman Havrylyak - mailto:roma@ukr.net
At 14:09 22.11.00, Havrylyak Roma wrote: >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... Using phorum 3.1.x with pgsql 7.x? There is a bug where phorum doesn't properly pass variable with pgsql version and ends up using wrong syntax which annoys pgsql. Fix is to use 3.2.x versions - latest is 3.2.7. Tomaz
"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