urgent: problems with query_limit - Mailing list pgsql-general

From Herbert Liechti
Subject urgent: problems with query_limit
Date
Msg-id 377A84E8.51A077F6@thinx.ch
Whole thread Raw
Responses help with SPI_ Please  (Mike Haberman <mikeh@ncsa.uiuc.edu>)
Re: [GENERAL] urgent: problems with query_limit  (Peter Eisentraut <peter@pathwaynet.com>)
Re: [GENERAL] urgent: problems with query_limit  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-general
Hi

We upgraded our system from 6.4 to the new 6.5 version. The set query_limit function is not working
anymore in 6.5.

db => set query_limit to '100';
SET VARIABLE
db => select * from table;

statement is returning all records from the table. What's wrong here?

Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~




pgsql-general by date:

Previous
From: Mike Haberman
Date:
Subject: help with SPI_ please !
Next
From: Mike Haberman
Date:
Subject: help with SPI_ Please