urgent: problems with query_limit

From: Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch>
To: postgres <pgsql-general(at)postgreSQL(dot)org>
Subject: urgent: problems with query_limit
Date: 1999-06-30 20:58:17
Message-ID: 377A84E8.51A077F6@thinx.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Liechti(at)thinx(dot)ch
ThinX networked business services Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Haberman 1999-06-30 21:50:19 help with SPI_<commands> please !
Previous Message Stephen Boyle 1999-06-30 20:44:05 Postgres Upsizing Tool for MSAccess 97