In 4.2 User Attributes, the word geqo should probably be changed to
enable_indexscan.
4.2 User Attributes...
A user can also set personal defaults for many of the run-time configuration
settings described in
Section 3.4. For example, if for some reason you want to disable index scans
(hint: not a good idea) anytime you connect, you can use
ALTER USER myname SET enable_indexscan TO off;
This will save the setting (but not set it immediately) and in subsequent
connections it will appear as though SET geqo TO off; had been called right
before the session started.
This probably should read:
A user can also set personal defaults for many of the run-time configuration
settings described in Section 3.4. For example, if for some reason you want
to disable index scans (hint: not a good idea) anytime you connect, you can
use
ALTER USER myname SET enable_indexscan TO off;
This will save the setting (but not set it immediately) and in subsequent
connections it will appear as though SET enable_indexscan TO off; had been
called right before the session started.
elein@varlena.com
--
------------------------------------------------------------------------------------------
elein@varlena.com Database Consulting www.varlena.com
It's a doggie dog world.