Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Christopher Kings-Lynne
Your pg_dump's actually invoke the pager? Are you manually starting psql, then doing \i dumpfile? Why would you do that rather than psql template1 dumpfile? Because I'm a dork :-). Seriously, sometimes it's useful. The most useful reason (and I wish you could turn it on with psql

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Tom Lane
Larry Rosenman [EMAIL PROTECTED] writes: On Mon, 11 Aug 2003, Bruce Momjian wrote: Larry Rosenman wrote: Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting an interactive \i of the dump file? Your pg_dump's actually invoke the

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Peter Eisentraut
Christopher Kings-Lynne writes: The most useful reason (and I wish you could turn it on with psql file) is the line number in the file where any errors occur. psql -f file will do that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Larry Rosenman
--On Tuesday, August 12, 2003 09:30:39 -0400 Tom Lane [EMAIL PROTECTED] wrote: Larry Rosenman [EMAIL PROTECTED] writes: 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

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Tom Lane
Larry Rosenman [EMAIL PROTECTED] writes: 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

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Larry Rosenman
On Mon, 11 Aug 2003, Bruce Momjian wrote: Larry Rosenman wrote: Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting an interactive \i of the dump file? Your pg_dump's actually invoke the pager? Are you manually starting psql,

[HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-14 Thread Larry Rosenman
Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting an interactive \i of the dump file? Thanks, LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-12 Thread Bruce Momjian
Larry Rosenman wrote: Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting an interactive \i of the dump file? Your pg_dump's actually invoke the pager? Are you manually starting psql, then doing \i dumpfile? Why would you do that

Re: [HACKERS] Change Request: \pset pager off in pg_dumpall

2003-08-11 Thread Larry Rosenman
--On Monday, August 11, 2003 20:36:11 -0400 Tom Lane [EMAIL PROTECTED] wrote: Larry Rosenman [EMAIL PROTECTED] writes: On Mon, 11 Aug 2003, Bruce Momjian wrote: Larry Rosenman wrote: Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off to prevent the setval() calls from halting