Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199406090335.UAA06768@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <m0qBWGg-000ftAC@rainbow.in-berlin.de>
From: rj@rainbow.in-berlin.de (Robert Joop)
Subject: pgperl for 4.2?
To: postgres@postgres.Berkeley.EDU (postgres mailing list)
Date: Thu, 9 Jun 1994 00:38:40 +0200 (MET DST)
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Length: 1575      
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 08 Jun 94 20:35:24 -0700
Resent-XMts: smtp

hi *,

has pgperl been ported to postgres 4.2 (and perl 4.036) already?

the code that's in 4.2's contrib can't be compiled because a symbol's
name (and meaning) has changed (it is commented out in a header file,
and substituting it with another #define that appears to have a similar
meaning, PORTALS_INITIAL_SIZE, leads to a pgperl that gets a SEGVIOL
during the `bmake runtest`. (actually, you'll only see this output if
you call `./pgperl testlibpq.pl` directly, because the pipe to tee
won't get flushed...):

~postgres/v4r2/src/contrib/pgperl> ./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)
[...10 lines deleted...]

Relation person after appends:
New tuple group:
name           age            location       
fred           50             (50,10)        
[...10 lines deleted...]

Testing copy:

Relation person after copy:
New tuple group:
name           age            location       
fred           50             (50,10)        
[...12 lines deleted...]
sally          39             (5,6)          

Testing other things:
Opening 2 portals:
Number of portals open: 2
Segmentation fault
~postgres/v4r2/src/contrib/pgperl> 
)

so, if anybody already made the fix, please tell us about it!

best,
 rj

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