From fay.du@versaterm.com Thu May 4 16:32:20 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1B6439F9C10 for ; Thu, 4 May 2006 13:32:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85260-02 for ; Thu, 4 May 2006 13:32:10 -0300 (ADT) X-Greylist: delayed 00:33:14.497611 by SQLgrey- Received: from smtp.versaterm.com (smtp.versaterm.info [216.208.41.121]) by postgresql.org (Postfix) with ESMTP id A84B09F9B76 for ; Thu, 4 May 2006 13:32:08 -0300 (ADT) Received: from fay (unknown [198.73.216.184]) by smtp.versaterm.com (Postfix) with ESMTP id 8D4E070003 for ; Thu, 4 May 2006 11:31:05 -0400 (EDT) From: "Fay Du" To: Subject: How can I read display message from a C function Date: Thu, 4 May 2006 11:31:04 -0400 Message-ID: <000f01c66f8f$c17f4df0$b8d849c6@versaterm.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01C66F6E.3A6DADF0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.25 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO, HTML_90_100, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200605/46 X-Sequence-Number: 25077 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C66F6E.3A6DADF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi All: I would like to put some message in my C function ( myTestFunction). Currently, I want to see time for each function call inside myTestFunction. The output to the screen commands are in myTestFunction. myTestFunction is called from postgresql. How can I see the messages? Thanks in advance. Fay ------=_NextPart_000_0010_01C66F6E.3A6DADF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All:

= I would like to put some message in my C function ( myTestFunction). Currently, I want to see time for each function call inside myTestFunction. The output to the screen commands are in myTestFunction. myTestFunction is = called from postgresql. How can I see the messages? = Thanks in advance.

Fay

------=_NextPart_000_0010_01C66F6E.3A6DADF0-- From schabi@logix-tt.com Fri May 5 08:17:31 2006 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 86FEB9FA4F2 for ; Fri, 5 May 2006 05:17:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85790-05 for ; Fri, 5 May 2006 05:17:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.logix-tt.com (unknown [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id EC9289FA294 for ; Fri, 5 May 2006 05:17:25 -0300 (ADT) Received: from kingfisher.intern.logix-tt.com (T8b23.t.pppool.de [89.55.139.35]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id BAEDC653D0; Fri, 5 May 2006 10:18:33 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id F12C618189F94; Fri, 5 May 2006 10:17:38 +0200 (CEST) Message-ID: <445B0A22.4010608@logix-tt.com> Date: Fri, 05 May 2006 10:17:38 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Debian Thunderbird 1.0.7 (X11/20051017) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Fay Du Cc: pgsql-sql@postgresql.org Subject: Re: How can I read display message from a C function References: <000f01c66f8f$c17f4df0$b8d849c6@versaterm.com> In-Reply-To: <000f01c66f8f$c17f4df0$b8d849c6@versaterm.com> X-Enigmail-Version: 0.93.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/57 X-Sequence-Number: 25088 Hi, Fay, Fay Du wrote: > I would like to put some message in my C function ( myTestFunction). > Currently, I want to see time for each function call inside > myTestFunction. The output to the screen commands are in myTestFunction. > myTestFunction is called from postgresql. How can I see the messages? Hmm, would statement logging help you? If not, you could use elog(NOTICE, "message with time"); HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org