Обсуждение: contrib-global.mk and sql.in question

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

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

--
Peter Eisentraut   peter_e@gmx.net

On Fri, 22 Aug 2003 22:31:26 -0600
Robert Creager <Robert_Creager@LogicalChaos.org> said something like:

>
> I'm using GNU sed version 4.0.3.
>

Sorry, missed the rest:

GNU make 3.80

Mandrake Linux 9.1

PG 7.4Beta1

--
 22:44:51 up 21 days, 15:26,  4 users,  load average: 2.00, 2.03, 2.03