| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch> |
| Cc: | postgres <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] urgent: problems with query_limit |
| Date: | 1999-07-01 04:53:22 |
| Message-ID: | 199907010453.AAA23590@candle.pha.pa.us |
| 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?
>
Use the new LIMIT syntax on a SELECT query. It will be removed in the
upcoming 6.5.1.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Bitmead | 1999-07-01 06:23:18 | Re: [GENERAL] JOIN exclusion problem |
| Previous Message | Jan Wieck | 1999-07-01 00:47:56 | Re: [HACKERS] RE: [GENERAL] urgent: problems with query_limit |