[GENERAL] RE: 7.0 psql, readline and history.
Thanks Jeff. I'm the guy that started that thread. Been meaning to get back to the problem but had other issues on the project. Now I know what to do next. Appreciate your posting the solution. -=michael=- * * Michael S. Kelly * 4800 SW Griffith Dr., Ste. 202 * Beaverton, OR 97005 USA * voice: (503)644-6106 x122 fax: (503)643-8425 * <[EMAIL PROTECTED]> * http://www.axian.com/ * *Axian: Software Consulting and Training * -Original Message- From: Jeffery Collins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 16, 2000 4:58 PM To: [EMAIL PROTECTED] Subject: 7.0 psql, readline and history. I saw a note a few days ago about the arrow keys not working in psql in 7.0. As I recall the answer was to make sure the configure script could find "readline.h". I had the same problem as the original questioner, and attempted the suggested fix. The fix did allow configure to find "readline.h" as well as "readline/readline.h", but the problem wasn't fixed. After some investigation (i.e. reading the source), I determined the real problem was my version of readline. It *appears* to me that 7.0 requires readline version 4.1 in order for the readline history features to work, whereas 6.5.3 was happy with an earlier version. When I updated my version of readline, the readline history functions started working. I hope this isn't a repeat of earlier mail on this topic (I only joined the mailing list about a week ago), and I hope it helps people with the same problem that I had. Jeff Collins
[GENERAL] Having trouble getting readline functional in psql
Hey all, Readline functionality not working in psql. I've installed PostgreSQL 7.0 RC1 on RedHat 6.2. I have configured using: --with-libraries=/usr/lib which is where the libreadline.so.3 file is. One of the things I've noticed, although I'm not sure of it's significance, is that when the configure routine checks for the readline.h file it returns "no". Any thoughts? Thanks, -=michael=-
RE: [GENERAL] Can't find destroydb command in 7.0
Thanks Stephan, dropdb worked just fine. Also, I was not at all offended by your previous suggestion. I'm still pretty new to Linux. This issue surfaces an opportunity for me to help the cause. As I go through the process of setting up PostgreSQL 7.0 and developing a new database in it, I could provide some QA on the documentation. Two items have already surfaced. The first, of course, is that destroydb is now dropdb in 7.0. The second is in the INSTALL document. In the section that describes how to make PostgreSQL start at boot-time there is the following paragraph: In RedHat Linux add a file /etc/rc.d/init.d/postgres.init which is based on the example in contrib/linux/. Then make a softlink to this file from /etc/rc.d/rc5.d/S98postgres.init. There's a much simpler way to accomplish this. Simply execute the following: contrib/linux/postgres.init.sh install Who would I pass these suggestions on to? -=michael=- -Original Message- From: Stephan Richter [mailto:[EMAIL PROTECTED]] Sent: Monday, April 24, 2000 9:53 PM To: Michael S. Kelly Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Can't find destroydb command in 7.0 At 09:16 PM 4/24/00 -0700, Michael S. Kelly wrote: >Maybe it's late, maybe it'll all be clear to me in the morning, but I seem >to have lost the destroydb command after installing PostgreSQL 7.0 RC1. I just checked. It is called dropdb now, to be consistent with other commands. Regards, Stephan -- Stephan Richter - (901) 573-3308 - [EMAIL PROTECTED] CBU - Physics & Chemistry; Framework Web - Web Design & Development PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391
[GENERAL] Starting a new project, any opinions about using 7.0?
I'm starting a new project. We've selected PostgreSQL and I'm wondering if we shouldn't just jump in with 7.0 and avoid conversion hassles later on. I guess the issues for me are: 1. Stability. How good is Beta 5 (it is 5 now isn't it?) 2. Documentation. Are the docs ready? 3. Support. Who out there can help when things go wrong? I'd also be interested in what you feel are the most compelling features of 7.0. Is it the foreign keys, the overhauled optimizer, the updated psql, or other features? Thanks, -=michael=-
[GENERAL] The "nl" RPMs.
What are the "nl" RPMs and when should I use them? -=michael=- ***** * Michael S. Kelly * 4800 SW Griffith Dr., Ste. 202 * Beaverton, OR 97005 USA * voice: (503)644-6106 x122 fax: (503)643-8425 * <[EMAIL PROTECTED]> * http://www.axian.com/ * *Axian: Software Consulting and Training *