> I see there are at least other two options for SET/SHOW/RESET commands:
> - KSQO
> - QUERY_LIMIT
>
> I would to underline the help is not updated about KSQO:
>
> hygea=> \h show
> Command: show
> Description: show current run-time environment
> Syntax:
> SHOW DateStyle|GEQO|R_PLANS|QUERY_LIMIT
>
> hygea=> \h reset
> Command: reset
> Description: set run-time environment back to default
> Syntax:
> RESET DateStyle|GEQO|R_PLANS|QUERY_LIMIT
>
> hygea=> \h set
> Command: set
> Description: set run-time environment
> Syntax:
> SET DateStyle TO
> 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'
> set GEQO TO 'ON[=#]'|'OFF'
> set R_PLANS TO 'ON'| 'OFF'
> set QUERY_LIMIT TO #
This is because KQSO is a workaround, that may even be gone by 6.4
final.
-- 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,
Pennsylvania19026