Skip site navigation (1) Skip section navigation (2)

\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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Gena GurchonokDate: 2000-06-30 13:28:37
Subject: Rule system
Previous:From: darcyDate: 2000-06-29 19:17:17
Subject: Bugs test

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group