X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id E29F9D1B51E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Oct 2003 13:37:57 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 66872-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  6 Oct 2003 10:37:14 -0300 (ADT)
Received: from ns.cnlo.ro (ns.cnlo.ro [81.12.171.70])
	by svr1.postgresql.org (Postfix) with ESMTP id CEA0DD1B523
	for <pgsql-sql@postgresql.org>; Mon,  6 Oct 2003 10:37:08 -0300 (ADT)
Received: from cnlo.ro (marian.cnlo.ro [192.168.10.64])
	by ns.cnlo.ro (8.12.8/8.12.8) with ESMTP id h96Dar4Q014913;
	Mon, 6 Oct 2003 16:36:53 +0300
Message-ID: <3F816EFA.2080500@cnlo.ro>
Date: Mon, 06 Oct 2003 16:32:42 +0300
From: Popeanga Marian <pmarian@cnlo.ro>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Popeanga Marian <pmarian@cnlo.ro>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Richard Huxton <dev@archonet.com>,
	pgsql-sql@postgresql.org
Subject: Re: output
References: <3F7BE74A.70407@cnlo.ro> <200310021201.06107.dev@archonet.com>
	<3F7C075C.5050500@cnlo.ro> <27018.1065105315@sss.pgh.pa.us>
	<3F7CF68F.1070202@cnlo.ro>
Content-Type: multipart/alternative;
	boundary="------------020101090108040602080006"
X-RAVMilter-Version: 8.4.4(snapshot 20030410) (ns.cnlo.ro)
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/66
X-Sequence-Number: 15466

--------------020101090108040602080006
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit



Popeanga Marian wrote:

>
>       I am using libpg inside a plugin.
> For oracle conections i can read the server output with this package 
> dbms_output.read_line (... ).
>    For pgsql is something similar for reading server output ?
>  
> Tom Lane wrote:
>
>>Popeanga Marian <pmarian@cnlo.ro> writes:
>>  
>>
>>>Now if i don't use psql from where i can read the output ?
>>>    
>>>
>>
>>If you're using libpq directly, you can install a notice processor hook
>>routine to catch NOTICE messages.  Otherwise they go to stderr.
>>
>>			regards, tom lane
>>
>>  
>>
>
Can you tell me more  about how to install a notice processor hook 
routine to catch NOTICE messages ?

Thanks,
/Marian

--------------020101090108040602080006
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
<br>
<br>
Popeanga Marian wrote:<br>
<blockquote type="cite" cite="mid3F7CF68F.1070202@cnlo.ro">
  <title></title>
       <br>
 &nbsp; &nbsp; &nbsp; I am using libpg inside a plugin. <br>
 For oracle conections i can read the server output with this package dbms_output.read_line 
(... ).<br>
 &nbsp; &nbsp;For pgsql is something similar for reading server output ?<br>
 &nbsp;<br>
 Tom Lane wrote:<br>
 
  <blockquote type="cite" cite="mid27018.1065105315@sss.pgh.pa.us">   
    <pre wrap="">Popeanga Marian <a class="moz-txt-link-rfc2396E"
 href="mailto:pmarian@cnlo.ro">&lt;pmarian@cnlo.ro&gt;</a> writes:
  </pre>
   
    <blockquote type="cite">     
      <pre wrap="">Now if i don't use psql from where i can read the output ?
    </pre>
   </blockquote>
   
    <pre wrap=""><!---->
If you're using libpq directly, you can install a notice processor hook
routine to catch NOTICE messages.  Otherwise they go to stderr.

			regards, tom lane

  </pre>
 </blockquote>
 <br>
 </blockquote>
Can you tell me more &nbsp;about how to install a notice processor hook routine
to catch NOTICE messages ?<br>
<br>
Thanks,<br>
/Marian<br>
</body>
</html>

--------------020101090108040602080006--