pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
psql does not save contents into file at end of command.
5+ messages / 3 participants
[nested] [flat]

* psql does not save contents into file at end of command.
@ 2006-12-24 10:18  Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Rajesh Kumar Mallah @ 2006-12-24 10:18 UTC (permalink / raw)
  To: pgsql-admin

Hi,

 this is psql8.2 client and server.

tradein_clients=> \o db.lst
tradein_clients=> \l  (till this point, there is nothing in file db.lst)
tradein_clients=> \q (now it saves) (also saves if another \o is issued)

Dunno till what extent this behavior is justified.

regds
mallah.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: psql does not save contents into file at end of command.
@ 2006-12-24 11:28  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Alvaro Herrera @ 2006-12-24 11:28 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; +Cc: pgsql-admin

Rajesh Kumar Mallah wrote:
> Hi,
> 
> this is psql8.2 client and server.
> 
> tradein_clients=> \o db.lst
> tradein_clients=> \l  (till this point, there is nothing in file db.lst)
> tradein_clients=> \q (now it saves) (also saves if another \o is issued)
> 
> Dunno till what extent this behavior is justified.

Maybe it is writing, just not fflushing?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: psql does not save contents into file at end of command.
@ 2006-12-24 11:48  Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  parent: Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Rajesh Kumar Mallah @ 2006-12-24 11:48 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; pgsql-admin

>
> >
> > Dunno till what extent this behavior is justified.
>
> Maybe it is writing, just not fflushing?


Alvaro,
i am reporting as an enduser. I feel  many would consider it buggy.

regds
mallah.

--
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: psql does not save contents into file at end of command.
@ 2006-12-27 16:27  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Tom Lane @ 2006-12-27 16:27 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; +Cc: pgsql-admin

"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> tradein_clients=> \o db.lst
> tradein_clients=> \l  (till this point, there is nothing in file db.lst)
> tradein_clients=> \q (now it saves) (also saves if another \o is issued)

> Dunno till what extent this behavior is justified.

I wasn't too excited about this, but on investigation, psql *does*
fflush() the \o file after each ordinary SQL command; it's only
backslash command output that doesn't necessarily reach the file
immediately.  This is inconsistent ... if we're going to do it for
regular commands seems like we should do it for backslash commands
too.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: psql does not save contents into file at end of command.
@ 2006-12-27 17:47  Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 5+ messages in thread

From: Rajesh Kumar Mallah @ 2006-12-27 17:47 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

On 12/27/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> writes:
> > tradein_clients=> \o db.lst
> > tradein_clients=> \l  (till this point, there is nothing in file db.lst)
> > tradein_clients=> \q (now it saves) (also saves if another \o is issued)
>
> > Dunno till what extent this behavior is justified.
>
> I wasn't too excited about this, but on investigation, psql *does*
> fflush() the \o file after each ordinary SQL command;


i see . I did not investigate to that extent , i thought it was for all.

it's only
> backslash command output that doesn't necessarily reach the file
> immediately.  This is inconsistent ... if we're going to do it for
> regular commands seems like we should do it for backslash commands
> too.


Thanks for the notice
and belated Merry Christmas.

Regds
mallah.

                        regards, tom lane
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-12-27 17:47 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-24 10:18 psql does not save contents into file at end of command. Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-24 11:28 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-12-24 11:48   ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-27 16:27 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-12-27 17:47   ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox