agora inbox for postgres@postgres.berkeley.edu  
help / color / mirror / Atom feed
Installing pgperl
3+ messages / 2 participants
[nested] [flat]

* Installing pgperl
@ 1994-08-30 15:34  Eric P Dean <ericdean@iastate.edu>
  0 siblings, 1 reply; 3+ messages in thread

From: Eric P Dean @ 1994-08-30 15:34 UTC (permalink / raw)
  To: legacy

I have POSTGRES v4.2 and PERL 4.036 running on a DEC 5000/133 in an MIT
Athena-like environment.  I tried bmake on pgperl and received the
following error messages.  I've read Paul Aoki's comments in the
Makefile and would like to know how to have the memcpy and memset return
void.  I'm not much of a computer whiz, so please make it as understandable
as possible.

Thank you!  And thanks to all who answered my question regarding
searching on seperate words in an attribute. Your answers were very helpful!

Eric Dean
Curator, Visual Resources Collection
College of Design, Iowa State University


root@pv081c.vincent> /local/postgres/xxbmake/bmake
/local/perl-4.036/usub/mus pg-libpq.mus > pg-libpq.c
cc -g -I/local/postgres/include -I/local/perl-4.036  -c pg-libpq.c
cfe: Warning: /usr/include/sys/param.h:389: Macro MIN redefined
cfe: Warning: /usr/include/sys/param.h:390: Macro MAX redefined
cfe: Error: /local/perl-4.036/perl.h, line 159: redeclaration of 'memcpy'; previous declaration at line 121 in file '/usr/include/string.h'
        extern char * memcpy();
        --------------^
cfe: Error: /local/perl-4.036/perl.h, line 159: Incompatible function
return type for this function 
        extern char * memcpy();
        --------------------^
cfe: Error: /local/perl-4.036/perl.h, line 175: redeclaration of
'memset'; previous declaration at line 123 in file
'/usr/include/string.h' 
        extern char *memset();
        -------------^
cfe: Error: /local/perl-4.036/perl.h, line 175: Incompatible function
return type for this function 
        extern char *memset();
        -------------------^
cfe: Error: pg-libpq.c, line 589: missing size for array 'portalnames'
            char portalnames[MAXPORTALS][32];
        ---------^
cfe: Error: pg-libpq.c, line 589: storage size for 'portalnames' isn't known
            char portalnames[MAXPORTALS][32];
        ---------^
cfe: Error: pg-libpq.c, line 589: 'MAXPORTALS' undefined, reoccurrences
will not be reported 
            char portalnames[MAXPORTALS][32];
        ---------------------^
cfe: Error: pg-libpq.c, line 590: missing size for array 'pnames'
            char *pnames[MAXPORTALS];
        ----------^
cfe: Error: pg-libpq.c, line 590: storage size for 'pnames' isn't known
            char *pnames[MAXPORTALS];
        ----------^
*** Error code 1

Stop.

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Installing pgperl
@ 1994-08-30 21:04  Paul M. Aoki <aoki@cs.berkeley.edu>
  parent: Eric P Dean <ericdean@iastate.edu>
  0 siblings, 0 replies; 3+ messages in thread

From: Paul M. Aoki @ 1994-08-30 21:04 UTC (permalink / raw)
  To: Eric P Dean <ericdean@iastate.edu>; +Cc: legacy

Eric P Dean <ericdean@iastate.edu> writes:
> I have POSTGRES v4.2 and PERL 4.036 running on a DEC 5000/133 in an MIT
> Athena-like environment.  I tried bmake on pgperl and received the
> following error messages.
> cfe: Error: pg-libpq.c, line 589: missing size for array 'portalnames'
>             char portalnames[MAXPORTALS][32];
>         ---------^

that's odd.  this shouldn't happen anymore, the pgperl that comes
with 4.2 (in src/contrib/pgperl) no longer uses MAXPORTALS.

faerie:aoki (366)> pwd
/usr/local/devel/postgres-v4r2/src/contrib/pgperl
faerie:aoki (367)> egrep MAXPORT pg-libpq.mus
faerie:aoki (368)> egrep ,v pg-libpq.mus 
 * /usr/local/devel/postgres-v4r2/src/contrib/pgperl/RCS/pg-libpq.mus,v 1.7 1994/06/16 11:37:21 aoki Exp
faerie:aoki (369)> 

the same checkin also obviated the need to dink your perl.h on ultrix
(i defined some perl-internal defines..)

however, one or more versions of the prerelease code were broken.  i
am guessing you have the alpha or beta code..?
--
  Paul M. Aoki          |  University of California at Berkeley
  aoki@CS.Berkeley.EDU  |  Dept. of EECS, Computer Science Division (#1776) 
                        |  Berkeley, CA 94720-1776

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Installing pgperl
@ 1994-09-01 16:33  Eric P Dean <ericdean@iastate.edu>
  0 siblings, 0 replies; 3+ messages in thread

From: Eric P Dean @ 1994-09-01 16:33 UTC (permalink / raw)
  To: legacy

I am still trying to get pgperl installed on my DEC 5000/133 running
Ultrix 4.3a with Postgres 4.2 and pgperl 4.036.

I ran the testlibpq.pl program and got a segmentation fault where it
starts working with portals.  The output from testlibpq.pl and a section
of code from testlibpq.pl follows.
Does anyone have any ideas as to why it may have bombed?

Thank you

Eric Dean
Curator, Visual Resources Collection
College of Design, Iowa State University

It looks like it blew-up on "@names = &PQpnames (0);" in the subroutine
test_rest of testlibpq.pl

sub test_rest {
    printf("Opening 2 portals:\n");
    &doPQexec ("begin");
    &doPQexec ("retrieve portal eportal (person.all)");
    &doPQexec ("fetch all in eportal");
    &doPQexec ("retrieve portal fportal (person.all)");
    &doPQexec ("fetch all in fportal");
    printf("Number of portals open: %d\n", &PQnportals(0));
    @names = &PQpnames (0);
    print "Portal names: ", join(', ',@names), ".\n";
    $p = &PQparray ("eportal");
    printf("Portal eportal %s asynchronous.\n",&PQrulep($p) ? "is" : "is not");
    printf("Portal eportal has %d tuples.\n",&PQntuples($p));
    printf("Portal eportal has %d instances.\n",&PQninstances($p));
    printf("Portal eportal has %d groups.\n",&PQngroups($p));


->pgperl /local/postgres/src/contrib/pgperl/testlibpq.pl
Destroying database pgperltest
Creating database pgperltest
Accessing database pgperltest

Creating relation person:
query = create person (name = char16, age = int4, location = point)

Relation person before appends:
New tuple group:
name           age            location       

Appending to relation person:
query = append person (name = "fred", age = 50, location = "(50,10)"::point)
query = append person (name = "fred", age = 60, location = "(60,10)"::point)
query = append person (name = "fred", age = 70, location = "(70,10)"::point)
query = append person (name = "fred", age = 80, location = "(80,10)"::point)
query = append person (name = "fred", age = 90, location = "(90,10)"::point)
query = append person (name = "fred", age = 100, location = "(100,10)"::point)
query = append person (name = "fred", age = 110, location = "(110,10)"::point)
query = append person (name = "fred", age = 120, location = "(120,10)"::point)
query = append person (name = "fred", age = 130, location = "(130,10)"::point)
query = append person (name = "fred", age = 140, location = "(140,10)"::point)
query = append person (name = "fred", age = 150, location = "(150,10)"::point)

Relation person after appends:
New tuple group:
name           age            location       
fred           50             (50,10)        
fred           60             (60,10)        
fred           70             (70,10)        
fred           80             (80,10)        
fred           90             (90,10)        
fred           100            (100,10)       
fred           110            (110,10)       
fred           120            (120,10)       
fred           130            (130,10)       
fred           140            (140,10)       
fred           150            (150,10)       

Testing copy:

Relation person after copy:
New tuple group:
name           age            location       
fred           50             (50,10)        
fred           60             (60,10)        
fred           70             (70,10)        
fred           80             (80,10)        
fred           90             (90,10)        
fred           100            (100,10)       
fred           110            (110,10)       
fred           120            (120,10)       
fred           130            (130,10)       
fred           140            (140,10)       
fred           150            (150,10)       
bill           21             (1,2)          
bob            61             (3,4)          
sally          39             (5,6)          

Testing other things:
Opening 2 portals:
Number of portals open: 2
Segmentation fault
->



==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1994-09-01 16:33 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-08-30 15:34 Installing pgperl Eric P Dean <ericdean@iastate.edu>
1994-08-30 21:04 ` Paul M. Aoki <aoki@cs.berkeley.edu>
1994-09-01 16:33 Installing pgperl Eric P Dean <ericdean@iastate.edu>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox