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: (view raw, whole thread or download thread mbox)
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
$ psql template1
Welcome to psql, the PostgreSQL interactive terminal.
template1=# \dS
          List of relations
      Name      |  Type   |  Owner
 pg_aggregate   | table   | postgres
 pg_am          | table   | postgres
 pg_amop        | table   | postgres
 pg_amproc      | table   | postgres
template1=# \d pg_am
ERROR:  getattproperties: no attribute tuple 1259 -2
template1=# create table test (id int, val int);
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 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.

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


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-2017 The PostgreSQL Global Development Group