From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | bj77 <jovino_blanco(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ORAFCE -> UTL_FILE -> pul_line |
Date: | 2012-01-13 16:52:58 |
Message-ID: | CAFj8pRC0QKbiqPaAH+SBU_epVvEngiw9gpibx-A495NJNL+8Wg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
2012/1/13 bj77 <jovino_blanco(at)hotmail(dot)com>:
> Hi,
>
> OS: SUSE LINUX
>
> I am writing a logfile (batch process) with the ORAFCE utilities of
> UTL_FILE.
> I recently observed that the logfile is not refreshed after every new entry
> written. It appears to me that the every 4096 bytes of data are written at
> the same time.
>
It doesn't flush after any write. Filebuffers are flushed when file is
closed or when function fflush is explicitly called.
Use utl_file.fflush(file utl_file.file_type) after write, and then
your logfile will be fresh every time.
Regards
Pavel Stehule
> Can anyone explain me this please? And is it possible to change that in
> order to write every line directly into a file (being able to see the
> current file input with putty or WINSCP)?
>
> Sorry for my english, i hope you did understand my question.
>
> Thanks a lot in advance!
>
> Saludos
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/ORAFCE-UTL-FILE-pul-line-tp5142399p5142399.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Reid Thompson | 2012-01-13 17:02:12 | PG9.1.2 -- 3 day old orphaned/non-responsive query -- pg_(cancel)(terminate)_backend has no effect |
Previous Message | seiliki | 2012-01-13 16:37:29 | Re: unnest array of row type |