Re: /* */ comments showing up in pg_stat_activity

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: /* */ comments showing up in pg_stat_activity
Date: 2003-04-25 16:17:32
Message-ID: 200304251617.h3PGHWZ24565@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Yes, we support /* */ comments.

---------------------------------------------------------------------------

Rajesh Kumar Mallah wrote:
>
>
>
> Hmm ..
> i just saw /* */ comments are being shown in current_query
> is it ok ?
>
> More importantly is it supposed to remain like that ?
> In that case i can tag every query with some identifier
> to know from which application it originated when i check
> em in pg_stat_activity !
>
>
> regds
> mallah.
>
> |
> | 14655172 | tradein_clients | 5886 | 100 | tradein | /*
> Inserting Branding Data
> Expected Time: 5 mins
> */
> INSERT into general.profile_master (userid, co_name, address, pincode, city,
> country_code, phone_no, mobile, fax_no, email, website, title1, fname1,
> mname1, lname1, desg1, title2, fname2, mname2, lname2, |
> | 14655172 | tradein_clients | 3118 | 100 | tradein | <IDLE>
>
>
>
> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-04-25 17:20:48 Re: [SQL] rewriting values with before trigger
Previous Message Rajesh Kumar Mallah 2003-04-25 16:10:49 /* */ comments showing up in pg_stat_activity