--On Tuesday, August 12, 2003 09:30:39 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
Larry Rosenman <[EMAIL PROTECTED]> writes:seems to do it for ANY SRF, if that helps any.Nope. There is no .psqlrc.
It seems to be new with 7.4cvs. (dunno about earlier 7.4), but it definitely did NOT happen with 7.3.x
Hmph. There have been some changes in 7.4 psql's pager support, but I can't see anything there that looks like it would cause this. And it (still) doesn't happen on my machine. Would you trace through PageOutput and see why it's deciding to use the pager for short output?
I.E. \d, and show all;.
LER
regards, tom lane
-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match