From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 6336 invoked from network); 15 Sep 2004 09:29:25 -0000 Received: from news.dotsrc.org (HELO a.mx.sunsite.dk) (130.225.247.88) by ns1.primenet.com.au with SMTP; 15 Sep 2004 09:29:25 -0000 Received: (qmail 19444 invoked from network); 15 Sep 2004 09:29:19 -0000 Received: from sunsite.dk (130.225.247.90) by a.mx.sunsite.dk with SMTP; 15 Sep 2004 09:29:19 -0000 Received: (qmail 16733 invoked by alias); 15 Sep 2004 09:28:35 -0000 Mailing-List: contact zsh-users-help@sunsite.dk; run by ezmlm Precedence: bulk X-No-Archive: yes X-Seq: 7995 Received: (qmail 16719 invoked from network); 15 Sep 2004 09:28:34 -0000 Received: from unknown (HELO a.mx.sunsite.dk) (130.225.247.88) by sunsite.dk with SMTP; 15 Sep 2004 09:28:34 -0000 Received: (qmail 17909 invoked from network); 15 Sep 2004 09:28:14 -0000 Received: from lhuumrelay3.lnd.ops.eu.uu.net (62.189.58.19) by a.mx.sunsite.dk with SMTP; 15 Sep 2004 09:28:12 -0000 Received: from MAILSWEEPER01.csr.com (mailhost1.csr.com [62.189.183.235]) by lhuumrelay3.lnd.ops.eu.uu.net (8.11.0/8.11.0) with ESMTP id i8F9S9v13519 for ; Wed, 15 Sep 2004 09:28:10 GMT Received: from EXCHANGE02.csr.com (unverified [192.168.137.45]) by MAILSWEEPER01.csr.com (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Wed, 15 Sep 2004 10:27:12 +0100 Received: from news01.csr.com ([192.168.143.38]) by EXCHANGE02.csr.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 15 Sep 2004 10:29:22 +0100 Received: from news01.csr.com (localhost.localdomain [127.0.0.1]) by news01.csr.com (8.12.11/8.12.11) with ESMTP id i8F9S4Wd008569 for ; Wed, 15 Sep 2004 10:28:04 +0100 Received: from csr.com (pws@localhost) by news01.csr.com (8.12.11/8.12.11/Submit) with ESMTP id i8F9S3lL008566 for ; Wed, 15 Sep 2004 10:28:04 +0100 Message-Id: <200409150928.i8F9S3lL008566@news01.csr.com> X-Authentication-Warning: news01.csr.com: pws owned process doing -bs To: zsh-users@sunsite.dk Subject: Re: PostgreSQL completion In-reply-to: <20040915064031.GA52150@ppe.happygiraffe.net> References: <20040915064031.GA52150@ppe.happygiraffe.net> Date: Wed, 15 Sep 2004 10:28:03 +0100 From: Peter Stephenson X-OriginalArrivalTime: 15 Sep 2004 09:29:22.0851 (UTC) FILETIME=[7C2ADF30:01C49B06] X-Spam-Checker-Version: SpamAssassin 2.63 on a.mx.sunsite.dk X-Spam-Level: X-Spam-Status: No, hits=0.0 required=6.0 tests=none autolearn=no version=2.63 X-Spam-Hits: 0.0 Dominic Mitchell wrote: > 1. I use psql to get information from the database. But what happens > if psql spits out an error? At the moment, it just messes up the > display... The usual method is simply to add 2>/dev/null to the command. If you want to be smarter about errors you need to work harder. > 2. How do you complete either a hostname or a path at the same point? > PostgreSQL accepts either a hostname or a directory containing a socket > after -h. The easy way is _alternative, assuming you have functions for both cases. _ssh does (after a bit of editing): _alternative \ 'hosts:remote host name:_ssh_hosts' \ 'users:login name:_ssh_users -qS@' -- Peter Stephenson Software Engineer CSR Ltd., Science Park, Milton Road, Cambridge, CB4 0WH, UK Tel: +44 (0)1223 692070 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************