Обсуждение: PL/pgSQL in template1?

Hi,

    I  wonder  if anyone ever played around with PL/pgSQL. So far
    (except for the missing Makefile) I got  no  response  if  it
    compiles/works on other platforms than my Linux.

    Since  there  are only a few details left in the rewrite code
    for 6.4 I would like to get back on it. I think 6.4  BETA  is
    the right time to check if it works on all the platforms (6.4
    is the first time we ship it).

    I would do it by adding a build/install with (errors  ignored
    first)  to the Makefiles.  Then another regression test could
    check if it works.

    Comments?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

Jan,

I have been hacking around trying to get a clean build without much luck.  I
have adjusted the compile options and fixed one casting problem to get all C
code compiled.  I also extracted all the external symbols successfully.
(AIX requirement)    However, I get the following message at link time:

    ld: 0711-362 ERROR: Glink code cannot be added for function: _ptrgl
        This function is used by compilers and must be called directly.

Shared libraries are a bit more tricky on AIX, but I thought I had the
routine pretty well figured out.    I am at a complete loss here.

Andreas, could you give it a try?

Jan Wieck wrote:

> Hi,
>
>     I  wonder  if anyone ever played around with PL/pgSQL. So far
>     (except for the missing Makefile) I got  no  response  if  it
>     compiles/works on other platforms than my Linux.
>
>     Since  there  are only a few details left in the rewrite code
>     for 6.4 I would like to get back on it. I think 6.4  BETA  is
>     the right time to check if it works on all the platforms (6.4
>     is the first time we ship it).
>
>     I would do it by adding a build/install with (errors  ignored
>     first)  to the Makefiles.  Then another regression test could
>     check if it works.
>
>     Comments?

>
> Jan,
>
> I have been hacking around trying to get a clean build without much luck.  I
> have adjusted the compile options and fixed one casting problem to get all C
> code compiled.  I also extracted all the external symbols successfully.
> (AIX requirement)    However, I get the following message at link time:
>
>     ld: 0711-362 ERROR: Glink code cannot be added for function: _ptrgl
>         This function is used by compilers and must be called directly.
>
> Shared libraries are a bit more tricky on AIX, but I thought I had the
> routine pretty well figured out.    I am at a complete loss here.
>
> Andreas, could you give it a try?

    That's  really interesting. The only difference (of interest)
    I can see between my Makefile and that of contrib/spi  (where
    refint  and  autoinc  are located which afaik are used in the
    regression test) is that I missed to  add  CFLAGS_SL  to  the
    CFLAGS. Seems that one only contains -fpic.

    Could you try to use

    CFLAGS+= $(CFLAGS_SL) -I$(LIBPQDIR) -I$(SRCDIR)/include

    in line 22 of my Makefile?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #