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:
(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.