Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C655A9FC053 for ; Thu, 12 Jul 2007 18:51:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 62499-09 for ; Thu, 12 Jul 2007 18:51:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 2D3379FC063 for ; Thu, 12 Jul 2007 18:51:11 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l6CLp4YK007335; Thu, 12 Jul 2007 14:51:04 -0700 Message-ID: <4696A2A8.9080305@commandprompt.com> Date: Thu, 12 Jul 2007 14:52:40 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: Benjamin Krajmalnik CC: Adam Witney , pgsql-admin@postgresql.org, "Abraham, Danny" Subject: Re: How can I tell that the underlying OS is Windows? References: <46969F61.5040701@commandprompt.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.90.3/3641/Wed Jul 11 18:57:08 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 12 Jul 2007 14:51:04 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/131 X-Sequence-Number: 26112 Benjamin Krajmalnik wrote: > My mistake. > I was connecting to remote machines and must have accidentally issued > the version on the same box :( How about this :) SELECT * FROM version() WHERE version ~* 'gcc.exe' OR version ~* 'msvc'; You probably want to replace msvc with whatever that would be on MSVC. Joshua D. Drake > > BSD is returning: > > "PostgreSQL 8.1.5 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC) > 3.4.4 [FreeBSD] 20050518" > > >> -----Original Message----- >> From: Joshua D. Drake [mailto:jd@commandprompt.com] >> Sent: Thursday, July 12, 2007 3:39 PM >> To: Benjamin Krajmalnik >> Cc: Adam Witney; pgsql-admin@postgresql.org; Abraham, Danny >> Subject: Re: [ADMIN] How can I tell that the underlying OS is Windows? >> >> Benjamin Krajmalnik wrote: >>> My Windows box says: >>> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) >>> 3.4.2 (mingw-special)" >>> >>> My BSD box says: >>> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) >>> 3.4.2 (mingw-special)" >>> >>> Seems to be the same >> Your bsd box appears to be connection to a postgresql on >> windows machine. >> >> Joshua D. Drake >> >> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 7: You can help support the PostgreSQL project by donating at >>> >>> http://www.postgresql.org/about/donate >>> >> >> -- >> >> === The PostgreSQL Company: Command Prompt, Inc. === >> Sales/Support: +1.503.667.4564 || 24x7/Emergency: >> +1.800.492.2240 Providing the most comprehensive PostgreSQL >> solutions since 1997 >> http://www.commandprompt.com/ >> >> Donate to the PostgreSQL Project: >> http://www.postgresql.org/about/donate >> PostgreSQL Replication: http://www.commandprompt.com/products/ >> >> > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/