Jaap Boender wrote
> Berndt Josef Wulf <wulf@dingo.ping.net.au> wrote:
> : I fear that there is a good reason for it, but in previous versions
> : postgresql didn't build because of serveral 64bit issues which
> : nolonger seems to be a show stopper.
> 
> It still doesn't build, I'm afraid. I got PostgreSQL working under 1.4.x
> with some changes to the source code (there was, apparently, no TAS
> implementation in NetBSD but I solved it by using one of the implementations
> supplied by Postgres). It still didn't work all the way; the \dt command from
> psql died with a very vague error message. But I could make tables and get
> data from them, so I was happy for the time being.
> 
> However, when I switched to 1.5, the show was over. It compiles fine from
> the pkgsrc (I just tried it once more), but the server dies with 'Bad system
> call' and I have no clue what is happening...and I don't want to delve into the
> source code. Compiling outside of pkgsrc yields the same result.
> 

Strange, it works here using the pkgsrc-current from a few weeks ago
see below. I could create a binary package and make it available via
ftp. What do you think?

cheerio Berndt

dingo# uname -srnp
NetBSD dingo 1.5 alpha
dingo# pkg_info postgresql
Information for postgresql-7.0.3:
 [...]
dingo#su pgsql
% psql phpgroupware
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

phpgroupware=#\dt
           List of relations
	  Name          | Type  | Owner
------------------------+-------+-------
 accounts               | table | pgsql
 addressbook            | table | pgsql
 applications           | table | pgsql
 [...]
preferences            | table | pgsql
profiles               | table | pgsql
todo                   | table | pgsql
(22 rows)
phpgroupware=# \ds
               List of relations
              Name             |   Type   | Owner 
-----------------------------+----------+-------
 accounts_account_id_seq     | sequence | pgsql
 addressbook_ab_id_seq       | sequence | pgsql
 calendar_entry_cal_id_seq   | sequence | pgsql
 [...]
 phpgw_hooks_hook_id_seq     | sequence | pgsql
 profiles_con_seq            | sequence | pgsql
 todo_todo_id_seq            | sequence | pgsql
(11 rows)
phpgroupware=#

-- 
Name    : Berndt Josef Wulf            | +++ With BSD on Packet Radio +++
E-Mail  : wulf@ping.net.au             |    tfkiss, tnt, dpbox, wampes
ICQ     : 18196098                     |  VK5ABN, Nairne, South Australia 
URL     : http://www.ping.net.au/~wulf | MBOX : vk5abn@vk5abn.#lmr.#sa.au.oc
Sysinfo : DEC AXPpci33+, NetBSD-1.5    | BBS  : vk5abn.#lmr.#sa.aus.oc