Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id BEE849FB270 for ; Fri, 3 Nov 2006 03:14:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 21354-06 for ; Fri, 3 Nov 2006 03:14:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id D09459FB260 for ; Fri, 3 Nov 2006 03:14:30 -0400 (AST) Received: (qmail 16264 invoked by uid 540); 3 Nov 2006 07:03:31 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:0(153.19.179.26):SA:0(-2.6/8.0):. Processed in 4.097688 secs); 03 Nov 2006 07:03:31 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 3 Nov 2006 07:03:27 -0000 Message-ID: <454AEC8A.6000406@informatyka.gdansk.pl> Date: Fri, 03 Nov 2006 08:15:22 +0100 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Tahir Tamba CC: pgsql-admin@postgresql.org Subject: Re: psql error References: <641ed974696e.454a7a33@courrier.uqam.ca> In-Reply-To: <641ed974696e.454a7a33@courrier.uqam.ca> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.336 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200611/15 X-Sequence-Number: 23542 If "more.com" (not more.exe) in windos XP Pro is not installed in WINDIR/system32 (WINDIR directory is usually after standard installation called WINDOWS), You can it find on install disk in directory "i386" as more.co_ - You shuold extract it with "extract.exe". You can use "more.exe" from DJGPP (gcc project for DOS) too, when You have install disk without "more.co_" (but it should be on this disk). I'm sure, that You know this, but: You If You can't call programs from WINDIR/system32 without call them with full path (this is abnormal situation), put line into Your "autoexec.bat": SET PATH=%PATH%;c:\windows\system32 ...and restart Windos Greetings Adam Tahir Tamba wrote: > Dear all, > > I installed the compiled version of PostgreSQL 8.1.5 on WinXP Pro OS > and I'm experiencing some difficulties using psql terminal to do some > commun tasks like adding columns and populate them with values. > > when executing the command for this statement: > > AddGeometryColumn ( [Table], > > [ Colonne_Geometrique ], > > [SRID], > > [ Type_Geometrie ], > > [Dimension ]); > > I receive the following error message: "more" is not recognized as an > intern command , an executable program or command files. > > This seems like a broken installation of Windows. So I could not seen > more.exe into my Win32Systems. > > Any idea or suggestion to resolve this would be appreciated > > Kind regards > > Tahir Tamba > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >