From s.shivaji@rediffmail.com Thu May 4 18:14:07 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6F5B89FA7B6 for ; Thu, 4 May 2006 15:14:07 -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 01885-03 for ; Thu, 4 May 2006 15:13:49 -0300 (ADT) X-Greylist: delayed 00:06:37.643379 by SQLgrey- Received: from rediffmail.com (unknown [203.199.83.108]) by postgresql.org (Postfix) with SMTP id 4DA6A9FA65C for ; Thu, 4 May 2006 15:13:47 -0300 (ADT) Received: (qmail 21376 invoked by uid 510); 4 May 2006 18:06:07 -0000 Date: 4 May 2006 18:06:07 -0000 Message-ID: <20060504180607.21375.qmail@webmail61.rediffmail.com> Received: from unknown (210.214.208.141) by rediffmail.com via HTTP; 04 may 2006 18:06:07 -0000 MIME-Version: 1.0 From: "Shivaji S" Reply-To: "Shivaji S" To: pgsql-admin@postgresql.org Subject: How to find current running process Content-type: multipart/alternative; boundary="Next_1146765967---0-203.199.83.108-21371" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.076 tagged_above=0 required=5 tests=BAYES_50, HTML_IMAGE_ONLY_08, HTML_MESSAGE, HTML_SHORT_LINK_IMG_1, MSGID_FROM_MTA_HEADER X-Spam-Level: **** X-Archive-Number: 200605/40 X-Sequence-Number: 21572 This is a multipart mime message --Next_1146765967---0-203.199.83.108-21371 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =0AHi,=0A=0A=0AIs there any command to find current running threads/queri= es on postgres.=0A=0Aand how to find the uptime of my database.Please guide= me=0A=0ARegards,=0AShivaji --Next_1146765967---0-203.199.83.108-21371 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0A 
=0AHi,
=0A
=0A
=0AIs there any command to find cu= rrent running threads/queries on postgres.
=0A
=0Aand how to find the= uptime of my database.Please guide me
=0A
=0ARegards,
=0AShivaji= =0A

=0A

=0A=0A --Next_1146765967---0-203.199.83.108-21371-- From htomeh@firstam.com Thu May 4 18:19:54 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5E8AC9F9C10 for ; Thu, 4 May 2006 15:19:54 -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 02419-03 for ; Thu, 4 May 2006 15:19:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9699D9F9B76 for ; Thu, 4 May 2006 15:19:40 -0300 (ADT) Received: from outbound-smtp.firstam.com (outbound-smtp8.firstam.com [69.87.54.13]) by svr4.postgresql.org (Postfix) with ESMTP id 999E05B68BB for ; Thu, 4 May 2006 18:19:39 +0000 (GMT) Received: from 10.48.129.31 by outbound-smtp.firstam.com with ESMTP ( Hello SMTP Relay); Thu, 04 May 2006 11:19:06 -0700 X-Server-Uuid: A2519771-17FD-438B-B41E-237CBEBED851 Received: from unknown (HELO pisgsna01smmx01.ana.firstamdata.com) ( [172.17.88.35]) by FAEMSNA01SMXS01.firstam.com with ESMTP; 04 May 2006 11:19:07 -0700 Received: from pisgsna01sxch21.ana.firstamdata.com (Not Verified[172.17.88.71]) by pisgsna01smmx01.ana.firstamdata.com with NetIQ MailMarshal 6.0 Service Pack 1a (v6,0,3,33) id ; Thu, 04 May 2006 11:19:07 -0700 Received: from pisgsna01sxch01.ana.firstamdata.com ([172.17.88.70]) by pisgsna01sxch21.ana.firstamdata.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 4 May 2006 11:19:06 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Re: How to find current running process Date: Thu, 4 May 2006 11:19:06 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] How to find current running process Thread-Index: AcZvprZsZ1qWy7++RKiwTJPCaU9thQAAClnw From: "Tomeh, Husam" To: "Shivaji S" , pgsql-admin@postgresql.org X-OriginalArrivalTime: 04 May 2006 18:19:06.0554 (UTC) FILETIME=[3AEE11A0:01C66FA7] X-TMWD-Spam-Summary: SEV=1.1; DFV=A2006050406; IFV=2.0.6,4.0-7; RPD=4.00.0004; RPDID=303030312E30413039303230312E34343541343342452E303035463A5343464D413534333432342D462D2F4E4553574B563534472F71554B6D71577A564237673D3D; ENG=IBF; TS=20060504181907; CAT=NONE; CON=NONE; X-WSS-ID: 68449A102784714689-01-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C66FA7.3ABD0F06" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/41 X-Sequence-Number: 21573 This is a multi-part message in MIME format. ------_=_NextPart_001_01C66FA7.3ABD0F06 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable You may use the pg_stat_activity view to find out what's running on the database, ie. select * from pg_stat_activity ; You may also use the pg_postmaster_start_time() function to find out postmaster startup time, ie. select pg_postmaster_start_time() ; =20 ---- =20 =20 Husam=20 =20 http://firstdba.googlepages.com =20 ________________________________ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Shivaji S Sent: Thursday, May 04, 2006 11:06 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] How to find current running process Hi, Is there any command to find current running threads/queries on postgres. and how to find the uptime of my database.Please guide me Regards, Shivaji=20 =20 =20 ********************************************************************** This message contains confidential information intended only for the use = of the addressee(s) named above and may contain information that is legal= ly privileged. If you are not the addressee, or the person responsible f= or delivering it to the addressee, you are hereby notified that reading, = disseminating, distributing or copying this message is strictly prohibite= d. If you have received this message by mistake, please immediately noti= fy us by replying to the message and delete the original message immediat= ely thereafter. Thank you. =0D =20 FADLD Tag ********************************************************************** ------_=_NextPart_001_01C66FA7.3ABD0F06 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable
You may= =20use the=20 pg_stat_activity view to find out what's running on the database, ie. sel= ect *=20 from pg_stat_activity ;
You may= =20also use the=20 pg_postmaster_start_time() function to find out postmaster startup time, = ie. =20 select pg_postmaster_start_time() ;
 
----
 
    Husam
    http://firstdba.googlepages.com<= /A>
 


From: pgsql-admin-owner@postgresql.or= g=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Shivaji=20 S
Sent: Thursday, May 04, 2006 11:06 AM
To:=20 pgsql-admin@postgresql.org
Subject: [ADMIN] How to find current= =20 running process


Hi,


Is there any command to find current running=20 threads/queries on postgres.

and how to find the uptime of my=20 database.Please guide me

Regards,
Shivaji



=20

**********************************************************************=
This=20 message contains confidential information intended only for the use of th= e=20 addressee(s) named above and may contain information that is legally=20 privileged.  If you are not the addressee, or the person responsible= =20for=20 delivering it to the addressee, you are hereby notified that reading,=20 disseminating, distributing or copying this message is strictly=20 prohibited.  If you have received this message by mistake, please=20 immediately notify us by replying to the message and delete the original = message=20 immediately thereafter.

Thank you.

          &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =              = FADLD=20 Tag
***********************************************************= ***********

------_=_NextPart_001_01C66FA7.3ABD0F06-- From s.shivaji@rediffmail.com Thu May 4 20:29:18 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D4AD99FA65C for ; Thu, 4 May 2006 17:29:18 -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 55248-04 for ; Thu, 4 May 2006 17:28:58 -0300 (ADT) X-Greylist: delayed 00:06:39.358559 by SQLgrey- Received: from rediffmail.com (unknown [203.199.83.31]) by postgresql.org (Postfix) with SMTP id D21A29F9B76 for ; Thu, 4 May 2006 17:28:57 -0300 (ADT) Received: (qmail 32051 invoked by uid 510); 4 May 2006 20:21:17 -0000 Date: 4 May 2006 20:21:17 -0000 Message-ID: <20060504202117.32050.qmail@webmail46.rediffmail.com> Received: from unknown (210.214.208.141) by rediffmail.com via HTTP; 04 may 2006 20:21:17 -0000 MIME-Version: 1.0 From: "Shivaji S" Reply-To: "Shivaji S" To: "Tomeh,Husam" Cc: pgsql-admin@postgresql.org Subject: Re: How to find current running process Content-type: multipart/alternative; boundary="Next_1146774077---0-203.199.83.31-32046" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.876 tagged_above=0 required=5 tests=AWL, BAYES_00, HTML_30_40, HTML_IMAGE_ONLY_28, HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: * X-Archive-Number: 200605/47 X-Sequence-Number: 21579 This is a multipart mime message --Next_1146774077---0-203.199.83.31-32046 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline tom thanks for the input ,but the below queries doesn't support for my post= gres version 7.1.1 it shows the error =0A=0AERROR: Function 'pg_postmaster= _start_time()' does not exist=0AUnable to identify a function that satisfie= s the given argument types=0AYou may need to add explicit typecasts=0A=0ARe= gards,=0AShivaji=0A=0AOn Thu, 04 May 2006 Tomeh,Husam wrote :=0A>You may us= e the pg_stat_activity view to find out what's running on the=0A>database, = ie. select * from pg_stat_activity ;=0A>You may also use the pg_postmaster_= start_time() function to find out=0A>postmaster startup time, ie. select pg= _postmaster_start_time() ;=0A>=0A>----=0A>=0A> Husam=0A> http://fir= stdba.googlepages.com=0A>=0A>=0A>________________________________=0A>=0A> F= rom: pgsql-admin-owner@postgresql.org=0A>[mailto:pgsql-admin-owner@postgres= ql.org] On Behalf Of Shivaji S=0A>Sent: Thursday, May 04, 2006 11:06 AM=0A>= To: pgsql-admin@postgresql.org=0A>Subject: [ADMIN] How to find current runn= ing process=0A>=0A>=0A>=0A>=0A>Hi,=0A>=0A>=0A>Is there any command to find = current running threads/queries on=0A>postgres.=0A>=0A>and how to find the = uptime of my database.Please guide me=0A>=0A>Regards,=0A>Shivaji=0A>=0A>=0A= >=0A>=0A>ignature-home.htm/1507191490@Middle5?PARTNER=3D3>=0A>=0A>********= **************************************************************=0A>This mess= age contains confidential information intended only for the use of the addr= essee(s) named above and may contain information that is legally privileged= . If you are not the addressee, or the person responsible for delivering i= t to the addressee, you are hereby notified that reading, disseminating, di= stributing or copying this message is strictly prohibited. If you have rec= eived this message by mistake, please immediately notify us by replying to = the message and delete the original message immediately thereafter.=0A>=0A>= Thank you.=0A>=0A> FADLD Tag=0A>********= **************************************************************=0A --Next_1146774077---0-203.199.83.31-32046 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0Atom thanks for the input ,but the below queries doesn't support for m= y postgres version 7.1.1 it shows the error
=0A
=0AERROR:  Func= tion 'pg_postmaster_start_time()' does not exist
=0AUnable to identify a= function that satisfies the given argument types
=0AYou may need to add= explicit typecasts
=0A
=0ARegards,
=0AShivaji
=0A
=0AOn Thu= , 04 May 2006 Tomeh,Husam wrote :
=0A>You may use the pg_stat_activit= y view to find out what's running on the
=0A>database, ie. select * f= rom pg_stat_activity ;
=0A>You may also use the pg_postmaster_start_t= ime() function to find out
=0A>postmaster startup time, ie. select pg= _postmaster_start_time() ;
=0A>
=0A>----
=0A>
=0A>&= nbsp;   Husam
=0A>    http://firstdba.googlepages.co= m
=0A>
=0A>
=0A>________________________________
=0A&g= t;
=0A> From: pgsql-admin-owner@postgresql.org
=0A>[mailto:pgsq= l-admin-owner@postgresql.org] On Behalf Of Shivaji S
=0A>Sent: Thursd= ay, May 04, 2006 11:06 AM
=0A>To: pgsql-admin@postgresql.org
=0A&g= t;Subject: [ADMIN] How to find current running process
=0A>
=0A>= ;
=0A>
=0A>
=0A>Hi,
=0A>
=0A>
=0A>Is th= ere any command to find current running threads/queries on
=0A>postgr= es.
=0A>
=0A>and how to find the uptime of my database.Please g= uide me
=0A>
=0A>Regards,
=0A>Shivaji
=0A>
=0A&g= t;
=0A>
=0A>
=0A><http://adworks.rediff.com/cgi-bin/Ad= Works/sigclick.cgi/www.rediff.com/s
=0A>ignature-home.htm/1507191490@= Middle5?PARTNER=3D3>
=0A>
=0A>******************************= ****************************************
=0A>This message contains co= nfidential information intended only for the use of the addressee(s) named = above and may contain information that is legally privileged.  If you = are not the addressee, or the person responsible for delivering it to the a= ddressee, you are hereby notified that reading, disseminating, distributing= or copying this message is strictly prohibited.  If you have received= this message by mistake, please immediately notify us by replying to the m= essage and delete the original message immediately thereafter.
=0A>=0A>Thank you.
=0A>
=0A>         =                     &nbs= p;     FADLD Tag
=0A>**************************************= ********************************
=0A=0A

=0A

=0A=0A --Next_1146774077---0-203.199.83.31-32046-- From smarlowe@g2switchworks.com Thu May 4 20:46:47 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 80EEA9F9B76 for ; Thu, 4 May 2006 17:46:47 -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 56741-08 for ; Thu, 4 May 2006 17:46:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id AF1739F9C10 for ; Thu, 4 May 2006 17:46:33 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 4 May 2006 20:46:29 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 04 May 2006 15:46:29 -0500 Subject: Re: How to find current running process From: Scott Marlowe To: Shivaji S Cc: "Tomeh,Husam" , pgsql-admin@postgresql.org In-Reply-To: <20060504202117.32050.qmail@webmail46.rediffmail.com> References: <20060504202117.32050.qmail@webmail46.rediffmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1146775589.22037.53.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 04 May 2006 15:46:29 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/48 X-Sequence-Number: 21580 On Thu, 2006-05-04 at 15:21, Shivaji S wrote: > tom thanks for the input ,but the below queries doesn't support for my > postgres version 7.1.1 it shows the error > > ERROR: Function 'pg_postmaster_start_time()' does not exist > Unable to identify a function that satisfies the given argument types > You may need to add explicit typecasts That's a seriously OLD OLD OLD version of PostgreSQL. It has known data loss and stability bugs, as well as the deadly transaction wrap around issue. I'd recommend updating to at least 8.0.x where x is the highest version currently out yet) or better yet go to 8.1. You'll get no sympathy from anyone here if or when your 7.1.x database acts up... From tgl@sss.pgh.pa.us Thu May 4 20:48:22 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7CBA49FA65C for ; Thu, 4 May 2006 17:48:22 -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 57847-08 for ; Thu, 4 May 2006 17:48:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2F1CF9F9B76 for ; Thu, 4 May 2006 17:48:14 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k44KmBJ2004494; Thu, 4 May 2006 16:48:11 -0400 (EDT) To: "Shivaji S" cc: "Tomeh,Husam" , pgsql-admin@postgresql.org Subject: Re: How to find current running process In-reply-to: <20060504202117.32050.qmail@webmail46.rediffmail.com> References: <20060504202117.32050.qmail@webmail46.rediffmail.com> Comments: In-reply-to "Shivaji S" message dated "04 May 2006 20:21:17 -0000" Date: Thu, 04 May 2006 16:48:11 -0400 Message-ID: <4493.1146775691@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/49 X-Sequence-Number: 21581 "Shivaji S" writes: > tom thanks for the input ,but the below queries doesn't support for my post= > gres version 7.1.1 7.1.1? Egad. Update to something remotely modern, before it eats your data. The list of bugs fixed since then would curl your toes. See for yourself: http://developer.postgresql.org/docs/postgres/release.html regards, tom lane From steve@jla.com Fri May 5 07:48:28 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7FB389FA4F2 for ; Fri, 5 May 2006 04:48:28 -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 82798-01 for ; Fri, 5 May 2006 04:48:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bigmail.jlaltd.co.uk (bigmail.jla.com [81.171.198.99]) by postgresql.org (Postfix) with ESMTP id DB8389FA294 for ; Fri, 5 May 2006 04:48:21 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by bigmail.jlaltd.co.uk (Postfix) with ESMTP id 6680B2A9994; Fri, 5 May 2006 08:46:07 +0000 (GMT) Received: from bigmail.jlaltd.co.uk ([127.0.0.1]) by localhost (bigmail [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24499-08; Fri, 5 May 2006 08:46:04 +0000 (GMT) Received: from [192.168.0.228] (unknown [192.168.0.228]) by bigmail.jlaltd.co.uk (Postfix) with ESMTP id E7DAC2A994A; Fri, 5 May 2006 08:46:04 +0000 (GMT) Message-ID: <445B1110.506@jla.com> Date: Fri, 05 May 2006 08:47:12 +0000 From: Steve Burrows User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 Cc: Shivaji S , pgsql-admin@postgresql.org Subject: Re: How to find current running process References: <20060504202117.32050.qmail@webmail46.rediffmail.com> <4493.1146775691@sss.pgh.pa.us> In-Reply-To: <4493.1146775691@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------030207010905020504020304" X-Virus-Scanned: by amavisd-new at jla.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/53 X-Sequence-Number: 21585 This is a multi-part message in MIME format. --------------030207010905020504020304 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Got to echo this sentiment. I started using Postgresql commercially with version 6.5. I used Postgresql 7.1 from its release until earlier this year when it ate my data warehouse! Didn't upgrade because the solution was stable for several years then the whole thing blew up with the wraparound problem. I had to work very hard and was very lucky to recover it all. Please upgrade ASAP, it will be unpleasant, you may have to adjust code in some applications because of syntax changes etc., but that's a lot cheaper than losing your data. Steve Tom Lane wrote: > "Shivaji S" writes: > >> tom thanks for the input ,but the below queries doesn't support for my post= >> gres version 7.1.1 >> > > 7.1.1? Egad. Update to something remotely modern, before it eats > your data. The list of bugs fixed since then would curl your toes. > See for yourself: > http://developer.postgresql.org/docs/postgres/release.html > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > --------------030207010905020504020304 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Got to echo this sentiment. I started using Postgresql commercially with version 6.5.  I used Postgresql 7.1 from its release until earlier this year when it ate my data warehouse! Didn't upgrade because the solution was stable for several years then the whole thing blew up with the wraparound problem. I had to work very hard and was very lucky to recover it all. Please upgrade ASAP, it will be unpleasant, you may have to adjust code in some applications because of syntax changes etc., but that's a lot cheaper than losing your data.

Steve

Tom Lane wrote:
"Shivaji S" <s.shivaji@rediffmail.com> writes:
  
tom thanks for the input ,but the below queries doesn't support for my post=
gres version 7.1.1
    

7.1.1?  Egad.  Update to something remotely modern, before it eats
your data.  The list of bugs fixed since then would curl your toes.
See for yourself:
http://developer.postgresql.org/docs/postgres/release.html

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
  

--------------030207010905020504020304--