NetBSD Problem Report #10480

Received: (qmail 28035 invoked from network); 29 Jun 2000 21:46:12 -0000
Message-Id: <200006292146.PAA01718@biology.nmsu.edu>
Date: Thu, 29 Jun 2000 15:46:10 -0600 (MDT)
From: Brook Milligan <brook@biology.nmsu.edu>
Reply-To: brook@biology.nmsu.edu
To: gnats-bugs@gnats.netbsd.org
Subject: new package for spi-postgresql (server programming interface)
X-Send-Pr-Version: 3.95

>Number:         10480
>Category:       pkg
>Synopsis:       new package for spi-postgresql (server programming interface)
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          closed
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Thu Jun 29 21:47:00 +0000 2000
>Closed-Date:    Sat Jul 15 01:24:15 +0000 2000
>Last-Modified:  Sat Jul 15 01:24:15 +0000 2000
>Originator:     Brook Milligan
>Release:        NetBSD-1.4/i386
>Organization:
Brook G. Milligan                      Internet:  brook@nmsu.edu
Department of Biology
New Mexico State University            Telephone:  (505) 646-7980
Las Cruces, New Mexico  88003  U.S.A.  FAX:        (505) 646-5665
>Environment:

System: NetBSD biology.nmsu.edu 1.4 NetBSD 1.4 (BIOLOGY) #0: Tue Nov 23 11:51:18 MST 1999 root@biology.nmsu.edu:/usr/src/sys/arch/i386/compile/BIOLOGY i386


>Description:
	When postgresql is normally installed, the header files needed
to extend the backend (e.g., to write triggers or functions) are not
installed.  Consequently, it is impossible to write triggers or
functions without manually dredging these files from the extracted
source code.  This package installs a bunch of extra header files to
support programming backend extensions.

Note that this package does not pass pkglint.  It is patterned exactly
after the series of postgresql packages, all of which include a
Makefile.common.  pkglint does not know about that file, and hence
complains about an incorrectly formated Makefile.  Nevertheless, I
think the Makefile is ok.
>How-To-Repeat:
	Install postgresql package and try to include spi.h or trigger.h.
>Fix:
	Install new package at ftp://biology.nmsu.edu/pub/packages/spi-postgresql.tar.gz

>Release-Note:
>Audit-Trail:

From: "Johnny C. Lam" <lamj@stat.cmu.edu>
To: brook@biology.nmsu.edu
Cc: lamj@stat.cmu.edu, gnats-bugs@gnats.netbsd.org
Subject: Re: pkg/10480: new package for spi-postgresql (server programming interface)
Date: Fri, 14 Jul 2000 02:22:50 -0400

 Hi,

 	I'm the maintainer of the postgresql packages.  I noticed your
 PR for a package to install the PostgreSQL SPI header files.  I think
 those headers should be installed with the base postgresql package
 since /usr/pkg/include/pgsql/executor/spi.h, which is installed with
 the base package, #includes many of those headers you mentioned, and
 is thus currently broken.  What I wanted to know is how you came up
 with that list of headers in the package you submitted?

 	Thanks,

      -- Johnny C. Lam <lamj@stat.cmu.edu>
         Department of Statistics, Carnegie Mellon University
         http://www.stat.cmu.edu/~lamj/


From: Brook Milligan <brook@biology.nmsu.edu>
To: lamj@stat.cmu.edu
Cc: gnats-bugs@gnats.netbsd.org
Subject: Re: pkg/10480: new package for spi-postgresql (server programming interface)
Date: Fri, 14 Jul 2000 08:13:49 -0600 (MDT)

 Johnny,

 	   I'm the maintainer of the postgresql packages.  I noticed your
    PR for a package to install the PostgreSQL SPI header files.  I think
    those headers should be installed with the base postgresql package
    since /usr/pkg/include/pgsql/executor/spi.h, which is installed with
    the base package, #includes many of those headers you mentioned, and
    is thus currently broken.  What I wanted to know is how you came up
    with that list of headers in the package you submitted?

 Probably a better idea to add this to the postgresql package.  

 I was writing some triggers and needed to include spi.h and
 trigger.h.  I kept adding stuff until all the headers were found
 during the compile.

 I did not really analyze in detail the header interrelationships, so
 the list may not be complete or it may include a few extras.  However,
 I can compile things that include those two files, which I can't do
 with the standard install.

 I think the postgresql folks will be doing a more complete audit and
 cleanup of headers in the future.

 Also, the people doing the linux rpms have a similar list if you want
 to check around and compare.

 By the way, have you updated the postgresql package to 7.0.2?  Last I
 checked it was at 7.0.

 Cheers,
 Brook

From: "Johnny C. Lam" <lamj@stat.cmu.edu>
To: Brook Milligan <brook@biology.nmsu.edu>
Cc: lamj@stat.cmu.edu, gnats-bugs@gnats.netbsd.org
Subject: Re: pkg/10480: new package for spi-postgresql (server programming interface) 
Date: Fri, 14 Jul 2000 17:36:21 -0400

 Brook Milligan <brook@biology.nmsu.edu> writes:
 > I did not really analyze in detail the header interrelationships, so
 > the list may not be complete or it may include a few extras.  However,
 > I can compile things that include those two files, which I can't do
 > with the standard install.

 I think I'll just make a list of all necessary includes for all the
 installed postgresql headers and add the missing files.

 > By the way, have you updated the postgresql package to 7.0.2?  Last I
 > checked it was at 7.0.

 Yes, the package was recently updated.

 Thanks,

      -- Johnny C. Lam <lamj@stat.cmu.edu>
         Department of Statistics, Carnegie Mellon University
         http://www.stat.cmu.edu/~lamj/
State-Changed-From-To: open->closed 
State-Changed-By: jlam 
State-Changed-When: Fri Jul 14 18:22:25 PDT 2000 
State-Changed-Why:  
Necessary headers were added to main postgresql package. 
>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.