Bug??: getattproperties fails !!

From: Jan Ehrhardt <ehrhardt(at)medinf(dot)mu-luebeck(dot)de>
To: bugs(at)postgreSQL(dot)org, pgsql-bugs(at)postgreSQL(dot)org
Subject: Bug??: getattproperties fails !!
Date: 2000-07-06 12:35:31
Message-ID: 39647D13.AEB0E34B@medinf.mu-luebeck.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================

POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jan Ehrhardt
Your email address : ehrhardt(at)medinf(dot)mu-luebeck(dot)de

System Configuration
---------------------
Architecture (example: Intel Pentium) : SGI Octane SI (MIPS R10000)

Operating System (example: Linux 2.0.26 ELF) :IRIX 6.4

PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.1

Compiler used (example: gcc 2.8.0) : MIPS PRO CC 7.2

Please enter a FULL description of your problem:
------------------------------------------------
As far as I know the installation procedure finish sucessfully. gmake
runcheck
runs fine.
Postmaster is running and I can connect with psql.
(For configuration and installation details see
http://www.medinf.mu-luebeck.de/~ehrhardt/HowTo/HowToCompilePostgreSQL.html)

I have created a user and do the following:

createdb -e mydb
CREATE DATABASE "mydb"
CREATE DATABASE
bert:~$psql
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

ehrhardt=> \dt
No relations found.
ehrhardt=> CREATE TABLE friend (
ehrhardt(> first CHAR(20),
ehrhardt(> last CHAR(20),
ehrhardt(> age INTEGER
ehrhardt(> );
CREATE
ehrhardt=> \dt
List of relations
Name | Type | Owner
--------+-------+----------
friend | table | ehrhardt
(1 row)

ehrhardt=> \d friend
ERROR: getattproperties: no attribute tuple 1259 -2 <======

But the insert and select works:
ehrhardt=>INSERT INTO friend VALUES ('oliver','schmitt',33);
ehrhardt=> SELECT * FROM friend
ehrhardt-> \g
first | last | age
----------------------+----------------------+-----
oliver | schmitt | 33
(1 row)

ehrhardt=> \d friend
ERROR: getattproperties: no attribute tuple 1259 -2

But the getattpropeties still fails !!!!

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

see above, is reproducible for every table I create.
The same problem occurs using the postgres user for creating the
database and the table.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

sorry, no idea.

Regards,

Jan

--
-----------------------
Jan Ehrhardt
mailto:ehrhardt(at)medinf(dot)mu-luebeck(dot)de
-----------------------

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-07-06 14:07:20 Re: Obscure bug
Previous Message Andreas Schwab 2000-07-06 10:02:55 Re: [PATCHES] Patch for Linux-IA64