Обсуждение: Re: \d+ and \dd

Поиск
Список
Период
Сортировка

Re: \d+ and \dd

От
"Greg Sabino Mullane"
Дата:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> 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


Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200203061746

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE8hpy8vJuQZxSWSsgRAqq6AJsESSkMkMBA6OtOOCSQ0NKmQwMvzQCffrhR
X4PRSDd171M4gFAJnKpH7Rk=
=XlKx
-----END PGP SIGNATURE-----




Re: \d+ and \dd

От
Thomas Good
Дата:
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
------------------------------------------------------------------------