Received: from mail2.panix.com (mail2.panix.com [166.84.1.73]) by postgresql.org (Postfix) with ESMTP id 26F67476C6C for ; Thu, 7 Mar 2002 08:47:08 -0500 (EST) Received: from mailhost.nrnet.org (unknown [166.84.192.39]) by mail2.panix.com (Postfix) with ESMTP id 964978FE5; Thu, 7 Mar 2002 08:47:10 -0500 (EST) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.11.4/8.11.4) with UUCP id g27Dcbi04013; Thu, 7 Mar 2002 08:38:37 -0500 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id IAA08815; Thu, 7 Mar 2002 08:48:49 -0500 Date: Thu, 7 Mar 2002 08:48:49 -0500 (EST) From: Thomas Good To: Greg Sabino Mullane Cc: pgsql-sql@postgresql.org Subject: Re: \d+ and \dd In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/82 X-Sequence-Number: 6963 On Wed, 6 Mar 2002, Greg Sabino Mullane wrote: > > Hi, did the default behaviour of \d+ and \dd change on 7.2 (?) > > I'm getting errors: > > > \d+ -> function obj_description(oid, unknown) does not exist > > \dd -> no such attribute or function 'classoid' > > You could have a mismatch of the psql client and the postgres backend > versions. See what this says: > > (psql -c "select version()" && psql -V) | grep SQL | head -2 Right! Thanks... :-) ------------------------------------------------------------------------ Thomas Good tomg@admin.nrnet.org Programmer/Analyst phone: 718-818-5528 Residential Services, Behavioral Health Services fax: 718-818-5056 Saint Vincent Catholic Medical Centers mobile: 917-282-7359 -- -- SQL Clinic - An Open Source Clinical Record www.sqlclinic.net ------------------------------------------------------------------------