From fernando@es.uniovi.etsimo.afrodita Tue Apr 13 16:07 BST 1993 Received: from hes.csc.liv.ac.uk by lune.csc.liv.ac.uk with SMTP (16.8/LUCS-1.3) id AA11386; Tue, 13 Apr 93 16:07:30 +0100 Received: from polar.etsiig.uniovi.es by hes.csc.liv.ac.uk with SMTP (16.6/LUCS-1.3) id AA24396; Tue, 13 Apr 93 16:07:06 +0100 Received: from afrodita.etsimo.uniovi.es by etsiig.uniovi.es (PMDF V4.2-10 #042B2) id <01GWYXM0YBSG8WVYYH@etsiig.uniovi.es>; Tue, 13 Apr 1993 17:07:11 +0100 (GMT) Received: by afrodita.etsimo.uniovi.es (5.52/890607.SGI) (for R.Turnbull@compsci.liverpool.ac.uk) id AA03288; Tue, 13 Apr 93 17:06:20 MDT Date: Tue, 13 Apr 1993 17:06:19 +0100 (MDT) From: fernando@es.uniovi.etsimo.afrodita (Fernando Ariznavarreta) Subject: Problems with Postgres DEFINE TYPE. To: R.Turnbull@uk.ac.liverpool.compsci (Rick Turnbull) Message-Id: <9304131506.AA03288@afrodita.etsimo.uniovi.es> X-Envelope-To: R.Turnbull@compsci.liverpool.ac.uk X-Mailer: ELM [version 2.4 PL20] Content-Type: text Content-Transfer-Encoding: 7BIT Content-Length: 1403 Status: RO Hi, Rick: We've got some trouble trying to create an array type of double precision float (float8), it seems to work ok, but when you create a class using the new type, append some data and make a retrieve, postgres seems to hang. Please, try this: define type arrayfloat8( input= array_in, output= array_out, internallength= variable, element= float8 )\g create kk(l=arrayfloat8)\g append kk(l="{2,3,4}")\g append kk(l="{2,3,5,6}")\g retrieve (kk.all)\g Now, postgres deads. If you use float4 elements instead of float8, everything seems to work OK. I have another question, Do you know if array_in and array_out work with fixed length arrays? We tried to define a complex type as... define type complex( input= array_in, output= array_out, internallength= 16, element= float8 ) ... and it didn't work fine. It didn't work with float4 element type either. Best regards: Fernando -- Fernando Ariznavarreta Fernandez E-Mail:fernando@etsimo.uniovi.es Dpto. Explotacion y Prospeccion de Minas Phone: +34 8 510 4267 School of Mines. University of Oviedo +34 8 510 4336 Independencia, 13 Fax: +34 8 510 4242 Oviedo 33004, SPAIN +34 8 510 4340 From fernando@es.uniovi.etsimo.afrodita Thu Apr 15 12:53 BST 1993 Received: from polar.etsiig.uniovi.es by lune.csc.liv.ac.uk with SMTP (16.8/LUCS-1.3) id AA08209; Thu, 15 Apr 93 12:52:44 +0100 Received: from afrodita.etsimo.uniovi.es by etsiig.uniovi.es (PMDF V4.2-10 #042B2) id <01GX1JENPZ4G984JBZ@etsiig.uniovi.es>; Thu, 15 Apr 1993 13:52:45 +0100 (GMT) Received: by afrodita.etsimo.uniovi.es (5.52/890607.SGI) (for R.Turnbull@compsci.liverpool.ac.uk) id AA07240; Thu, 15 Apr 93 13:51:58 MDT Date: Thu, 15 Apr 1993 13:51:58 +0100 (MDT) From: fernando@es.uniovi.etsimo.afrodita (Fernando Ariznavarreta) Subject: Problems with monitor. In-Reply-To: <9304150827.AA18513@bobr.csc.liv.ac.uk> from "R.Turnbull@compsci.liverpool.ac.uk" at Apr 15, 93 09:27:03 am To: R.Turnbull@uk.ac.liverpool.compsci Message-Id: <9304151151.AA07240@afrodita.etsimo.uniovi.es> X-Envelope-To: R.Turnbull@compsci.liverpool.ac.uk X-Mailer: ELM [version 2.4 PL20] Content-Type: text Content-Transfer-Encoding: 7BIT Content-Length: 1044 Status: RO Hi, Rick: Thanks for your quick answer. We've run into another problem. This time it is with monitor. When you connect to the backend using monitor and make several sintax errors (two or three) in the querys, the backend disconnects and you have to restart (exit monitor and begin a new one). I don't know if this is a problem with monitor itself or with the backend. Are you going to port 4.1 version if the postgres team doesn't support HPUX? It would be very interesting, as they've fixed a lot of bugs, and added new capabilities. Regards, Fernando. P.S. somewhere in the documentation I've read that array_in and array_out only work with variable length arrays (not fixed length). -- Fernando Ariznavarreta Fernandez E-Mail:fernando@etsimo.uniovi.es Dpto. Explotacion y Prospeccion de Minas Phone: +34 8 510 4267 School of Mines. University of Oviedo +34 8 510 4336 Independencia, 13 Fax: +34 8 510 4242 Oviedo 33004, SPAIN +34 8 510 4340 From spf@EDU.Berkeley.cory Thu Apr 15 13:59 BST 1993 Received: from cory.Berkeley.EDU by lune.csc.liv.ac.uk with SMTP (16.8/LUCS-1.3) id AA09263; Thu, 15 Apr 93 13:59:06 +0100 Received: by cory.Berkeley.EDU (5.65/Ultrix3.0-C) id AA00737; Thu, 15 Apr 1993 05:58:40 -0700 From: spf@EDU.Berkeley.cory (Sebastian Fernandez) Message-Id: <9304151258.AA00737@cory.Berkeley.EDU> Subject: Re: Postgres port to HP-UX To: R.Turnbull@uk.ac.liverpool.compsci Date: Thu, 15 Apr 1993 05:58:40 -0700 (PDT) In-Reply-To: <9304150846.AA18574@bobr.csc.liv.ac.uk> from "R.Turnbull@compsci.liverpool.ac.uk" at Apr 15, 93 09:46:14 am X-Mailer: ELM [version 2.4 PL21] Content-Type: text Content-Length: 2610 Status: RO > > I have appended a message you sent to me on Jan 28th about postgres on > HP Series 700 machines. I noticed that a few weeks ago the new version of > postgres was released - are there no longer any plans to port postgres > to HPUX? > > Is there likely to be an HPUX version soon? If not, then I will have a go > myself - would it be possible to make the ".tar.Z" available without the > executables in ie.just the source in order to make this easier? > > Thanks, > > Regards, > Rik Turnbull. > > .=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=. > | | | > | Richard Turnbull | HPUX Porting & Archive Centre | > | | Dept. Computer Science | > | E-mail: | University of Liverpool | > | rik@compsci.liverpool.ac.uk | Liverpool L69 3BX | > | | England | > | Phone: (051) 794 3704 | | > | | | > .=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=. > > ------------------------------------------------------------------------------- > > > Thanks for the offer to download the files to us, but we are actually just > > putting in the finishing touches on our port (the mail I sent you yesterday > > should have said "finishing" not "starting" :)). I will, however, use your > > solution to the alignment problem (it probably would have taken me weeks > > to find that pragma). > > > > I am interested in your decision to use shared libraries for the dynamic > > loading. Were you successful in using "ld -A"? We currently are having > > problems with the dynamic loading due to what I believe is a bug in "ld" > > and are hoping that the bug is fixed in 9.0. The idea of using shared > > libraries has been suggested to me by various people. In what ways did you > > find shared libraries "better" than the "ld -A" solution? If you have found > > a significant advantage in using shared libraries, I may be able to > > convince the rest of the Postgres team to switch to shared libraries for > > the dynamic loading (it does seem a lot more portable). > > > > Thanks in advance for the info... > > > > Sebastian Fernandez > > > The port will probalby be coming in the next release. We're ironing out the bugs and making sure Postgres 4.1 works with HP-UX 9.01. Sebastian Fernandez