On Tue, 6 Feb 2001 josef.watzko@altavista.net wrote:

=> Maybe there are still problems with IEEE math lib.
=>
=> http://mail-index.netbsd.org/port-alpha/2001/01/25/0002.html
=>
=> >next i tested postgresql. the one from package
=> >collection failed many regression tests. upon working >with the postgresql developers, we got rid
=> >of all but two problems which seemed to be due to >floating point. at that point i posted the initial >message about IEEE.

With all of these recent messages about Postgres on Alpha, I made the
version in pkgsrc.  It appears to work, on the whole.  But, does anyone
else have problems with "\d" not working?  It returns "ERROR:
getattproperties: no attribute tuple 1259 -2" on my stock build.  A WWW
search seemed to imply this was a compiler optimisation problem.  Can
someone who has just built Postgres from pkgsrc try this:

>>>>>
~ paul@hawkwind$ 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

paul=# create table foo (bar integer);
CREATE
paul=# \d foo
ERROR:  getattproperties: no attribute tuple 1259 -2
paul=# select * from foo;
 bar
-----
(0 rows)

paul=# insert into foo values (23);
INSERT 18985 1
paul=# select * from foo;
 bar
-----
  23
(1 row)

paul=# \d foo
ERROR:  getattproperties: no attribute tuple 1259 -2
paul=#
<<<<<

So, you can work with the table, just not describe it.  The side-effect
of this problem is that pgaccess won't list defined tables, meaning you
can't work on them within pgaccess.

Cheers,

Paul.

e-mail: paul@gromit.dlib.vt.edu

"Without music to decorate it, time is just a bunch of boring production
 deadlines or dates by which bills must be paid."
        --- Frank Vincent Zappa