I see there's still the command:

SET QUERY_LIMIT  (even in the docs)
but it doesn't work.
prova=> select * from test limit 1;
 num|flt8
----+----
1.00|   1
(1 row)

prova=>
prova=> set query_limit = '1';
SET VARIABLE
prova=> select * from test;
  num| flt8
-----+-----
 1.00|    1
 2.34|2.343
-3.00|   -3
(3 rows)

prova=> show query_limit;
NOTICE:  query limit is 1
SHOW VARIABLE

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



Wed, 16 Jun 1999 17:28:39 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
SET QUERY_LIMIT bug report
> I see there's still the command:
> 
> SET QUERY_LIMIT  (even in the docs)
> but it doesn't work.
> prova=> select * from test limit 1;
>  num|flt8
> ----+----
> 1.00|   1
> (1 row)
> 

Yep, broken:
	
	test=> set query_limit = '1';
	SET VARIABLE
	test=> select * from pg_language;
	lanname |lanispl|lanpltrusted|lanplcallfoid|lancompiler   
	--------+-------+------------+-------------+--------------
	internal|f      |f           |            0|n/a           
	lisp    |f      |f           |            0|/usr/ucb/liszt
	C       |f      |f           |            0|/bin/cc       
	sql     |f      |f           |            0|postgres      


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 16 Jun 1999 11:40:24 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] SET QUERY_LIMIT bug report
I had the idea we were going to remove QUERY_LIMIT now that we have
the LIMIT clause?  There were good arguments advanced that QUERY_LIMIT
is actually dangerous, since it could (for example) prevent trigger
rules from operating as intended.

			regards, tom lane

Wed, 16 Jun 1999 11:56:39 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] SET QUERY_LIMIT bug report 
> I had the idea we were going to remove QUERY_LIMIT now that we have
> the LIMIT clause?  There were good arguments advanced that QUERY_LIMIT
> is actually dangerous, since it could (for example) prevent trigger
> rules from operating as intended.
> 
> 			regards, tom lane
> 


OK.  Easily removed, especially since it doesn't work.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 16 Jun 1999 11:58:57 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] SET QUERY_LIMIT bug report
>I had the idea we were going to remove QUERY_LIMIT now that we have
>the LIMIT clause?  There were good arguments advanced that QUERY_LIMIT
>is actually dangerous, since it could (for example) prevent trigger
>rules from operating as intended.

Yes. We should remove set query_limit before 6.5.1...
--
Tatsuo Ishii

Thu, 17 Jun 1999 07:01:04 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] SET QUERY_LIMIT bug report 
> >I had the idea we were going to remove QUERY_LIMIT now that we have
> >the LIMIT clause?  There were good arguments advanced that QUERY_LIMIT
> >is actually dangerous, since it could (for example) prevent trigger
> >rules from operating as intended.
> 
> Yes. We should remove set query_limit before 6.5.1...
> --
> Tatsuo Ishii
> 

Agreed.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 16 Jun 1999 18:03:17 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] SET QUERY_LIMIT bug report
Bruce Momjian ha scritto:

> > I had the idea we were going to remove QUERY_LIMIT now that we have
> > the LIMIT clause?  There were good arguments advanced that QUERY_LIMIT
> > is actually dangerous, since it could (for example) prevent trigger
> > rules from operating as intended.
> >
> >                       regards, tom lane
> >
>
> OK.  Easily removed, especially since it doesn't work.
>

We need to remove it even from docs.
(psql help, user guide and man pages)

Jose'



Thu, 17 Jun 1999 15:14:48 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
Re: [HACKERS] SET QUERY_LIMIT bug report
> Bruce Momjian ha scritto:
> 
> > > I had the idea we were going to remove QUERY_LIMIT now that we have
> > > the LIMIT clause?  There were good arguments advanced that QUERY_LIMIT
> > > is actually dangerous, since it could (for example) prevent trigger
> > > rules from operating as intended.
> > >
> > >                       regards, tom lane
> > >
> >
> > OK.  Easily removed, especially since it doesn't work.
> >
> 
> We need to remove it even from docs.
> (psql help, user guide and man pages)

Yes, that will be done too.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 17 Jun 1999 09:48:34 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] SET QUERY_LIMIT bug report