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

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 wo

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

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 broadcast)-

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 actual

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 Because I'm a dork :-). > > Seriously, sometimes it's useful. The most useful reason (and I wish you could turn it on with psql < file)

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 halti