\d* won't work in 7.0.2? - Mailing list pgsql-bugs

Dear PostgreSQL people,

I'm baffled at this: \d (and friends) won't give me the definition of a
table, view, function, etc:

$ initdb /var/lib/pgsql
...stuff...
$ psql template1
Welcome to psql, the PostgreSQL interactive terminal.
...stuff...
template1=# \dS         List of relations     Name      |  Type   |  Owner
----------------+---------+----------pg_aggregate   | table   | postgrespg_am          | table   | postgrespg_amop
 | table   | postgrespg_amproc      | table   | postgres 
...stuff...
template1=# \d pg_am
ERROR:  getattproperties: no attribute tuple 1259 -2
template1=# create table test (id int, val int);
CREATE
template1=# \dt   List of relationsName | Type  |  Owner
------+-------+----------test | table | mgiovann
(1 row)

template1=# \d test
ERROR:  getattproperties: no attribute tuple 1259 -2
template1=# \da
ERROR:  getattproperties: no attribute tuple 1247 -2
template1=# \dd
ERROR:  get_attdisbursion: no attribute tuple 16932 -2
template1=# \q
$

The system I'm using is a fresh installation of the 7.0.2-2.ppc.rpm's on
an MkLinux DR3 running on a PowerMac 8100/80. More specifically:

* No exported shell variables were set, the location of pgsql files
(bin, lib, database) and directories is exactly as the distribution
expects: /var/lib/pgsql

* No command line options were set, a simple "postmaster -D
/var/lib/pgsql" command was issued.

* Installation was, basically, "rpm -i postgresql*"

* "createuser mgiovann" was executed, with create database/user permissions.

* Version is:PostgreSQL 7.0.2 on powerpc-iso-8859-1-linux-gnu, compiled by gcc 2.95.2

* I've installed from the PPC RPM's, version 7.0.2-2 (found in
ftp://ftp.postgresql.org//pub/binary/v7.0.2/redhat-RPM/RPMS/PPC/ as of today).

* Platform info:PowerMac 8100/80, PowerPC 601/80MHz/32MB RAM

$ cat /proc/cpuinfo
processor       : 0
cpu             : 601
revision        : 0.1
bogomips        : 78.85
machine         : PowerMac
$ cat /proc/meminfo       total:    used:    free:  shared: buffers:  cached:
Mem:  33554432 27328512  6225920        0  1118208  7114752
Swap: 83881984   651264 83230720
MemTotal:     32768 kB
MemFree:       6080 kB
MemShared:        0 kB
Buffers:       1092 kB
Cached:        6948 kB
SwapTotal:    81916 kB
SwapFree:     81280 kB
$ cat /proc/version
Linux version 2.0.37-osfmach3 (root@build.mklinux.org) (gcc version egcs-2.91.6619990314 (egcs-1.1.2 release))
GENERIC_08alpha-20Fri Jul 30 11:07:38 
PDT 1999
$ gcc -v
Reading specs from /usr/lib/gcc-lib/ppc-redhat-linux/2.95.2/specs
gcc version 2.95.2 19990906 (prerelease)

Please note, I *did not* compile PostgreSQL myself.

I've tried grepping the documentation for something along the lines of
"getattproperties", or "\d", but I could find nothing relevant to my
problem. I sincerely hope it's not something stupid I did, the last
thing I'd want is to waste your time. If that's the case, please accept
my apologies in advance.

Thank you, and best regards,


Matías Giovannini
Script S.A.
+5411-4325-6546
matias@k-bell.com

--
Microsoft shouldn't be broken up. It should be shut down.
-- Phil Agre