Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] LIMIT QUESTION

From: José Soares <jose(at)sferacarta(dot)com>
To: Martin Wong <martin(at)minook(dot)com(dot)sg>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] LIMIT QUESTION
Date: 1999-04-29 15:50:28
Message-ID: 37287FC4.7A1F330A@sferacarta.com (view raw or flat)
Thread:
Lists: 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'



In response to

pgsql-general by date

Next:From: Adriaan JoubertDate: 1999-04-29 18:02:16
Subject: Timing queries
Previous:From: Margarita BarvinokDate: 1999-04-29 15:32:22
Subject: RE: [GENERAL] LIMIT QUESTION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group