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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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