pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
\d+ and \dd
3+ messages / 2 participants
[nested] [flat]

* \d+ and \dd
@ 2002-03-06 20:56 Thomas Good <tomg@admin.nrnet.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Thomas Good @ 2002-03-06 20:56 UTC (permalink / raw)
  To: pgsql-sql

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'

TIA
------------------------------------------------------------------------
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
------------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: \d+ and \dd
@ 2002-03-06 22:49 Greg Sabino Mullane <greg@turnstep.com>
  2002-03-07 13:48 ` Re: \d+ and \dd Thomas Good <tomg@admin.nrnet.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Greg Sabino Mullane @ 2002-03-06 22:49 UTC (permalink / raw)
  To: pgsql-sql


-----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-----





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: \d+ and \dd
  2002-03-06 22:49 Re: \d+ and \dd Greg Sabino Mullane <greg@turnstep.com>
@ 2002-03-07 13:48 ` Thomas Good <tomg@admin.nrnet.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Thomas Good @ 2002-03-07 13:48 UTC (permalink / raw)
  To: Greg Sabino Mullane <greg@turnstep.com>; +Cc: pgsql-sql

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
------------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2002-03-07 13:48 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-06 20:56 \d+ and \dd Thomas Good <tomg@admin.nrnet.org>
2002-03-06 22:49 Re: \d+ and \dd Greg Sabino Mullane <greg@turnstep.com>
2002-03-07 13:48 ` Thomas Good <tomg@admin.nrnet.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox