============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Jan Ehrhardt
Your email address : ehrhardt@medinf.mu-luebeck.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@medinf.mu-luebeck.de
-----------------------
