Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id ECE649FBF13 for ; Wed, 11 Jul 2007 10:11:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 36511-05 for ; Wed, 11 Jul 2007 10:11:28 -0300 (ADT) X-Greylist: delayed 00:06:38.85968 by SQLgrey-1.7.5 Received: from web43139.mail.sp1.yahoo.com (web43139.mail.sp1.yahoo.com [216.252.121.69]) by postgresql.org (Postfix) with SMTP id B2B389FBEFF for ; Wed, 11 Jul 2007 10:11:33 -0300 (ADT) Received: (qmail 2830 invoked by uid 60001); 11 Jul 2007 13:04:51 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=I0rSSwS45I7hALJTHO11ls1xQ1LBwgO0ZvnSgpcJx6X4mfbEswfFCmt+dDW20dzywd1WTcQJERAGGeWgejLHNaQ/JwhI0XzqErTxu1C8kJLJKdLEaUqy0rlX8P6JPosN2Lo7xxCUYyBZQrwszEdju7beNgD7XK/JSO6/qMd2ZLI=; X-YMail-OSG: 2IOTR2cVM1lOALy6dAybNPfioGL8Jx50ZN4k.wJjYJkiBr6QpygZoMtbJ_.BsXhsf9kVFZVgHe5M7W24WqlIw8Op2XAnUg-- Received: from [80.255.47.130] by web43139.mail.sp1.yahoo.com via HTTP; Wed, 11 Jul 2007 06:04:51 PDT X-Mailer: YahooMailRC/651.41 YahooMailWebService/0.7.41.16 Date: Wed, 11 Jul 2007 06:04:51 -0700 (PDT) From: Mohd Ghalib Akhtar Subject: linux To: Tom Lane , Peter Eisentraut Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1313480943-1184159091=:2253" Message-ID: <468724.2253.qm@web43139.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/51 X-Sequence-Number: 28786 --0-1313480943-1184159091=:2253 Content-Type: text/plain; charset=ascii how to download linux 7.3 image file(means os) ? Take care Mohd.Ghalib Akhtar (India.M)9899868681 (Africa.M) +255787896861 ----- Original Message ---- From: Tom Lane To: Peter Eisentraut Cc: pgsql-sql@postgresql.org Sent: Tuesday, July 10, 2007 9:15:20 PM Subject: Re: [SQL] Database system identifier from SQL Peter Eisentraut writes: > Tom Lane wrote: >> Peter Eisentraut writes: >>> Is there a way to query the database system identifier that >>> pg_controldata outputs from SQL? >> >> Don't think so. Do you have a use-case for providing a function to >> return that? > I'd like to find out whether two connections are really to the same > server. Hmm. Seems a bit of an odd case, but on the other hand there might be applications for it in connection with management of backups and WAL-shipping and so forth. I have no objection to adding a function. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate ____________________________________________________________________________________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting --0-1313480943-1184159091=:2253 Content-Type: text/html; charset=ascii
how to download linux 7.3 image file(means os) ?

 
Take care
Mohd.Ghalib Akhtar
(India.M)9899868681
(Africa.M) +255787896861


----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgresql.org
Sent: Tuesday, July 10, 2007 9:15:20 PM
Subject: Re: [SQL] Database system identifier from SQL

Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane wrote:
>> Peter Eisentraut <peter_e@gmx.net> writes:
>>> Is there a way to query the database system identifier that
>>> pg_controldata outputs from SQL?
>>
>> Don't think so.  Do you have a use-case for providing a function to
>> return that?

> I'd like to find out whether two connections are really to the same
> server.

Hmm.  Seems a bit of an odd case, but on the other hand there might be
applications for it in connection with management of backups and
WAL-shipping and so forth.  I have no objection to adding a function.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate



Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games. --0-1313480943-1184159091=:2253--