Re: [GENERAL] LIMIT QUESTION - Mailing list pgsql-general

From José Soares
Subject Re: [GENERAL] LIMIT QUESTION
Date
Msg-id 37287FC4.7A1F330A@sferacarta.com
Whole thread Raw
In response to RE: [GENERAL] LIMIT QUESTION  ("Martin Wong" <martin@minook.com.sg>)
List pgsql-general
Martin Wong ha scritto:

> Sorry for the previous posting. The following worked.
>
> BTW, this affects just this database or throughout the entire postgresql
> server?
>

Only current_session;

>
> And, how does one reset this variable to max?
>

RESET QUERY_LIMIT;

______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'



pgsql-general by date:

Previous
From: Adriaan Joubert
Date:
Subject: Timing queries
Next
From: The Hermit Hacker
Date:
Subject: RE: [GENERAL] LIMIT QUESTION