NetBSD Problem Report #10704

Received: (qmail 14489 invoked from network); 28 Jul 2000 12:17:33 -0000
Message-Id: <200007281218.OAA00381@bilbo.mraveniste.cz>
Date: Fri, 28 Jul 2000 14:18:25 +0200 (CEST)
From: gandalf@mraveniste.cz
Reply-To: gandalf@bilbo.mraveniste.cz
To: gnats-bugs@gnats.netbsd.org
Subject: Problem in PostgreSQL 
X-Send-Pr-Version: 3.95

>Number:         10704
>Category:       pkg
>Synopsis:       "\d tablename" and perhaps other commands inside psql produce error
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          closed
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Fri Jul 28 12:18:00 +0000 2000
>Closed-Date:    Tue Feb 13 02:43:25 +0000 2001
>Last-Modified:  Tue Feb 13 02:43:25 +0000 2001
>Originator:     Ladislav Popov
>Release:        1.4.2
>Organization:

>Environment:

System: NetBSD bilbo.mraveniste.cz 1.4.2 NetBSD 1.4.2 (GENERIC) #0: Wed Mar 15 21:53:17 PST 2000 toddpw@leia.toddpw.net:/usr/src/sys/arch/macppc/compile/GENERIC macppc


>Description:
I sucessfuly compile and install all for postgresql server, it
works except command "\d tablename" what make error "getattproperties:no
attribute tuple XXX -2", where XXX is some number. I found the same problem
description on addresss
http://www.postgresql.org/mhonarc/pgsql-ports/2000-05/msg00026.html .

>How-To-Repeat:
I have to mention that I was using PostgreSQL 7.0.2 and I
was using standard pkgsrc instalation (by the way, maybe it is a good idea
to run initdb during instalation automaticaly)

>Fix:
I found the fix for postgresql 7.0 on Alpha at
ftp://ftp.wibble.net/pub/stuff/postgresql-7.0-alpha.patch.gz but I could not
tell you if it could help.

>Release-Note:
>Audit-Trail:
Responsible-Changed-From-To: gnats-admin->pkg-manager 
Responsible-Changed-By: fair 
Responsible-Changed-When: Mon Jul 31 10:21:27 PDT 2000 
Responsible-Changed-Why:  
minorly malformed PR assigned to the correct default responsible person. 
State-Changed-From-To: open->suspended 
State-Changed-By: jlam 
State-Changed-When: Sat Feb 10 15:43:49 PST 2001 
State-Changed-Why:  
It appears the proper fix for this involves changes to the backend to handle 
differences in integer sizes by proper casting.  The changes in the patch 
referred to in the Fix section of the PR are quite extensive in this regard, 
and as I don't have a great deal of knowledge about the PostgreSQL source 
code, I'm loath to simply apply the patch.  The documentation for the patch 
says that the next release (7.1) of PostgreSQL will incorporate these fixes, 
so the plan for pkgsrc is to update to 7.1 as soon as it is released and see 
if the problems still persist on macppc and alpha.  For now, this PR is 
suspended pending the next release of PostgreSQL, which will occur in March 
according to GreatBridge when I asked them at LinuxWorld. 

From: Berndt Josef Wulf <wulf@dingo.ping.net.au>
To: gnats-bugs@netbsd.org
Cc:  
Subject: Re: pkg/10704
Date: Tue, 13 Feb 2001 00:30:24 +1030 (CST)

 The patches refered to in pkg/PR10704 were successfully tested on a AXPpci33
 and have proven to fix the problems hightlighted in this PR.

 I don't see any reason to further delay the integration of this patch into the
 pkgsrc tree. The following code changes were made to ensure that this patch is 
 applied for NetBSD-alpha architectures only...


 --- Makefile.orig	Tue Feb 13 00:07:03 2001
 +++ Makefile	Tue Feb 13 00:01:19 2001
 @@ -10,7 +10,7 @@
  MAKEFILE=		GNUmakefile

  # Needs ELF clue, mips has no TAS implementation
 -NOT_FOR_PLATFORM=	*-*-alpha *-*-mips
 +#NOT_FOR_PLATFORM=	*-*-alpha *-*-mips

  .include "../../mk/bsd.prefs.mk"

 @@ -47,6 +47,11 @@
  .elif ${OPSYS} == "SunOS"
  ADDUSER=		useradd
  ADDGROUP=		groupadd
 +.endif
 +
 +.if ${MACHINE_ARCH} == "alpha"
 +post-patch:
 +	cd ${WRKSRC} && ${PATCH} < ${FILESDIR}/postgresql-7.0.3-alpha.diff
  .endif

  post-build:


 A diff against the current package sources containing the changes
 of the Makefile and added patchfile can be downloaded from 

 ftp://ftp.ping.net.au/pub/unix/db/postgresql-7.0.3-pkgsrc.diff

 using ACTIVE FTP!!!!

 cheerio Berndt
 -- 
 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 
State-Changed-From-To: suspended->closed 
State-Changed-By: jlam 
State-Changed-When: Mon Feb 12 18:41:18 PST 2001 
State-Changed-Why:  
The referred-to patch is now applied only for alpha, and was tested by 
Berndt Josef Wulf <wulf@ping.net.au> and confirmed to fix the problem noted 
in the PR. 
>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.51 2026/08/10 02:28:17 riastradh Exp $
$NetBSD: gnats_config.sh,v 1.10 2026/05/13 22:00:09 riastradh Exp $
Copyright © 1994-2026 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.