\d* won't work in 7.0.2?

From: Matías Giovannini <matias(at)k-bell(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: \d* won't work in 7.0.2?
Date: 2000-06-29 23:06:40
Message-ID: 395BD680.27998F3@k-bell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 | postgres
pg_am | table | postgres
pg_amop | table | postgres
pg_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 relations
Name | 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-unknown-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(at)build(dot)mklinux(dot)org) (gcc version egcs-2.91.66
19990314 (egcs-1.1.2 release)) GENERIC_08alpha-20 Fri 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(at)k-bell(dot)com

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gena Gurchonok 2000-06-30 13:28:37 Rule system
Previous Message darcy 2000-06-29 19:17:17 Bugs test