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