Skip site navigation (1) Skip section navigation (2)

g++ not working for postgresql extension languages?

From: Lonnie Cumberland <lonnie_cumberland(at)yahoo(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: g++ not working for postgresql extension languages?
Date: 2001-04-15 00:46:15
Message-ID: 20010415004615.35217.qmail@web12508.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-sql
Hi All again,

One more thing that I have tried.

If I now do a similar thing as in my previous message with the "funcs.c" file,
but this time with the "funcs.cc" file then I can get:

-------------------------------------------------------------------------
[root(at)Treazurac /test]# g++ -I./include -I./backend -O2 -Wall
-Wmissing-prototypes -Wmissing-declarations -I/usr/include/pgsql -I/usr/include
-fpic -c -o funcs.o funcs.cc

[root(at)Treazurac /test]# g++ -shared -o funcs.so funcs.o

[root(at)Treazurac /test]# ls

Makefile  Makefile.global  Makefile.port  funcs.cc  funcs.o  funcs.so* 
funcs.sql

[root(at)Treazurac /test]# pico -w funcs.sql

[root(at)Treazurac /test]# psql -f funcs.sql -d trdata
DROP
CREATE

[root(at)Treazurac /test]# psql trdata
Welcome to psql, the PostgreSQL interactive terminal.
 
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit
 
trdata=# select concat_text('a','b');
ERROR:  Can't find function concat_text in file /test/funcs.so
trdata=#         
--------------------------------------------------------------------------

And although I should not be running as "root", this is a test machine and it
is ok for the time being.

If I do the same thing as above, but using the "funcs.c" file (which is the
exact same file just renamed)
---------------------------------------------------------------------------
funcs.c and funcs.cc
-------------------------
#include "postgres.h"           // for variable length type
 
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <time.h>
 
#include <unistd.h>             // for unix crypt function
 
text *
concat_text(text *arg1, text *arg2);
 
text *
concat_text(text *arg1, text *arg2)
{
    int32 new_text_size = VARSIZE(arg1) + VARSIZE(arg2) - VARHDRSZ;
    text *new_text = (text *) malloc(new_text_size);
 
    memset((void *) new_text, 0, new_text_size);
    VARSIZE(new_text) = new_text_size;
    strncpy(VARDATA(new_text), VARDATA(arg1), VARSIZE(arg1)-VARHDRSZ);
    strncat(VARDATA(new_text), VARDATA(arg2), VARSIZE(arg2)-VARHDRSZ);
    return (new_text);
}                                                            
--------------------------------------------------------------------------

with funcs.sql
------------------
DROP FUNCTION concat_text(text, text);
CREATE FUNCTION concat_text(text, text) RETURNS text
     AS '/test/funcs.so' LANGUAGE 'c'; 
----------------------------------------------------------------------------

With the "funcs.c" file in place I get:
-----------------------------------------------------------------------------
[root(at)Treazurac /test]# gcc -I./include -I./backend -O2 -Wall
-Wmissing-prototypes -Wmissing-declarations -I/usr/include/pgsql -I/usr/include
-fpic -c -o funcs.o funcs.c

[root(at)Treazurac /test]# gcc -shared -o funcs.so funcs.o

[root(at)Treazurac /test]# psql -f funcs.sql -d trdata
DROP
CREATE

[root(at)Treazurac /test]# psql trdata
Welcome to psql, the PostgreSQL interactive terminal.
 
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit
 
trdata=# select concat_text('a','b');
 concat_text
-------------
 ab
(1 row)
 
trdata=#            
-----------------------------------------------------------------------------

so now I do not understand why the "gcc" version works and the "g++" version
does not?

Just a side note in that I can easliy compile c++ the examples in the
interfaces/libpq++ directory without any problems so that this is very strange
to me. 
 
I really need the "g++" version to work correctly as well?

Any ideas anyone?

Cheers
Lonnie



__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

In response to

Responses

pgsql-interfaces by date

Next:From: Lonnie CumberlandDate: 2001-04-15 00:53:26
Subject: Re: cpp Makefiles
Previous:From: Brett W. McCoyDate: 2001-04-15 00:41:09
Subject: DBD::Pg 0.96 and DBI 1.15 ignoring username and password

pgsql-sql by date

Next:From: Tom LaneDate: 2001-04-15 00:50:52
Subject: Re: Full outer join
Previous:From: Lonnie CumberlandDate: 2001-04-15 00:23:22
Subject: Re: cpp Makefiles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group