Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA05150 for ; Wed, 20 Oct 1999 13:24:49 -0400 (EDT) (envelope-from olly@lfix.co.uk) Received: from linda.lfix.co.uk (root@max01-002.enterprise.net [194.72.195.2]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id SAA07469; Wed, 20 Oct 1999 18:24:46 +0100 (GMT/BST) Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.9.3/8.9.3/Debian 8.9.3-6) with ESMTP id SAA15759; Wed, 20 Oct 1999 18:24:22 +0100 Message-Id: <199910201724.SAA15759@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.1.1 10/15/1999 (debian) X-URL: http://www.lfix.co.uk/oliver X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- KMLl*!h}B)u@TW|B}6 cc: Lamar Owen , Thomas Lockhart , pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Re: PostgreSQL-6.5.2-0.3 Comment In-reply-to: Message from Lamar Owen of Wed, 20 Oct 1999 12:22:43 EDT. <380DEC53.8B2F820A@wgcr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Wed, 20 Oct 1999 18:24:22 +0100 From: "Oliver Elphick" Lamar Owen wrote: >Thomas Lockhart wrote: >> \l (which lists databases, not tables) behaves itself on my RH5.2 >> system with the current development tree. > >In the interests of thoroughness, I did the following: >I took my production system (running the 6.5.1-0.7lo RPM's), and tried >\l, which worked fine. I then upgraded to the 6.5.2-1 RPM's, and tried >\l -- and it works fine. > >System is Mandrake 5.3 (linux kernel 2.0.36, glibc 2.0.7). I'll try it >against my RedHat 6.1 partition after I reboot into it here in a moment >(it's on this very notebook). And that's the result I get with Debian 6.5.2-2 - no problem found. So I conclude that it's something wrong in your database. Try doing `select * from pg_database;' (which does the same as \l) and see what results you get. Turn on backend debugging and logging and see what the error is. (I was confused by the mention of odbc; this problem doesn't have anything to do with odbc, does it?) -- Vote against SPAM: http://www.politik-digital.de/spam/ ======================================== Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "For the LORD God is a sun and shield; the LORD will give grace and glory; no good thing will he withhold from them that walk uprightly." Psalms 84:11