contrib-global.mk and sql.in question

Started by Robert Creagerover 22 years ago2 messagesbugs
Jump to latest
#1Robert Creager
Robert_Creager@LogicalChaos.org

Hey,

Just wondering if the rule:

%.sql: %.sql.in
sed 's,MODULE_PATHNAME,$$libdir/$*g' $< >$@

is supposed to produce files like this:

CREATE OR REPLACE FUNCTION pgxml_parse(text) RETURNS boolean
AS '$libdir/pgxml_dom' LANGUAGE c STRICT;

I'm using:

GNU sed version 4.0.3.
GNU make 3.80
Mandrake Linux 9.1
PG 7.4Beta1

I find the following patch makes it work for me, but I'm not sure if this is a
bug, feature, or something else?

*** contrib-global.mk.orig      2003-08-22 22:20:33.000000000 -0600
--- contrib-global.mk   2003-08-22 22:22:26.000000000 -0600
***************
*** 225,231 ****

ifneq (,$(MODULES)$(MODULE_big))
%.sql: %.sql.in
! sed 's,MODULE_PATHNAME,$$libdir/$*,g' $< >$@
endif

  ifdef PROGRAM
--- 225,231 ----

ifneq (,$(MODULES)$(MODULE_big))
%.sql: %.sql.in
! @sed 's:MODULE_PATHNAME:$(libdir)/$*:g' $< >$@
endif

ifdef PROGRAM

--
22:17:58 up 21 days, 14:59, 4 users, load average: 2.10, 2.04, 2.01

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Robert Creager (#1)
Re: contrib-global.mk and sql.in question

Robert Creager writes:

Just wondering if the rule:

%.sql: %.sql.in
sed 's,MODULE_PATHNAME,$$libdir/$*g' $< >$@

is supposed to produce files like this:

CREATE OR REPLACE FUNCTION pgxml_parse(text) RETURNS boolean
AS '$libdir/pgxml_dom' LANGUAGE c STRICT;

Yes.

See also <http://www.postgresql.org/docs/7.3/static/xfunc-c.html&gt;.

--
Peter Eisentraut peter_e@gmx.net