Thread: DBD::Pg 1.32 ready for testing
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A new version of DBD::Pg is about to be released (1.32), and we need your help to test it out. If you use DBD::Pg, please download and test the latest release candidate. At the very least, running "make test" and reporting any problems would be of great help. The latest version can be found here: http://backpan.cpan.org/authors/id/R/RU/RUDY/ Currently the latest is "DBD-Pg-1.32_2.tar.gz" but please check the directory to see if there is anything newer. You can always get the latest work-in-progress via cvs by logging in with a password of "anonymous" and using: :pserver:anonymous@gborg.postgresql.org:/usr/local/cvsroot/dbdpg You can find out more information about the project, submit a bug or a feature request, and learn about the mailing list at: http://gborg.postgresql.org/project/dbdpg/ - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200402200653 -----BEGIN PGP SIGNATURE----- iD8DBQFANfYrvJuQZxSWSsgRAuQIAKCAWz+yHdkDo4VWOLPo0pJUX3SU9ACg0DAn E1FHuzdOtuhJcr1ySIoSKIk= =Yps3 -----END PGP SIGNATURE-----
Hi everybody I defined a function returning refcursor. CREATE FUNCTION cursorname (refcursor, character varying, character varying) RETURNS refcursor ... which does a select with username and serachphrase. If I call BEGIN; SELECT cursorname(`test`,`username`,`searchphrase`); MOVE 10 in test; FETCH 25 from test; COMMIT; inside psql everything works well. If I put this code into a scriptfile and call it, I get the following errormessage: cannot handle multiple result groups Why? What does this mean? I use a webserver which has 'one' persistent connection to the database. Executing the script the connection breaks. Trying to do a rollback the database returns that there is no transaction in progress. Any help is welcome Regards Conni
Cornelia Boenigk wrote: > Hi everybody > > I defined a function returning refcursor. > > CREATE FUNCTION cursorname (refcursor, character varying, character > varying) RETURNS refcursor ... > which does a select with username and serachphrase. > > If I call > > BEGIN; > SELECT cursorname(`test`,`username`,`searchphrase`); > MOVE 10 in test; > FETCH 25 from test; > COMMIT; > > inside psql everything works well. If I put this code into a > scriptfile and call it, I get the following errormessage: > > cannot handle multiple result groups > > Why? What does this mean? > > I use a webserver which has 'one' persistent connection to the > database. Executing the script the connection breaks. Trying to do a > rollback the database returns that there is no transaction in > progress. > > Any help is welcome Sure seems like whatever database client you're using doesn't really support transactions. Is is possible that each SQL command is being issued seperatly to the backend in "unchained" mode? You might want to provide the list with some details on the Postgres client you're using and how you're using it. Then, someone with experience with that client can make a specific suggestion. -- Bill Moran Potential Technologies http://www.potentialtech.com
Greetings, I have a Linux RedHat 9.0 computer. It has 1G memory. Is there anybody who could help me to fine tune the Kernel for PgSql, and also the with the proper settings for the PgSql server. I have two additional java program running on that computer, otherwise I used a custom installation with the minimal neccessary packages (No X-Server is initalled). I read the docuentation, and also the PostgreSQL Hardware Performance Tuning by Bruce Momjian. Both of them was very usefull, I could manage to come up with the configuration. Everything works fine, but I'm not sure I have chosen the best settings. Thank you in advance. Kind regards, Yuri ps. I almost forgot; I need 64 connections at the same times, and the max record length is aroung 1024 bytes.
Bill Moran <wmoran@potentialtech.com> writes:
> Cornelia Boenigk wrote:
>> BEGIN;
>> SELECT cursorname(`test`,`username`,`searchphrase`);
>> MOVE 10 in test;
>> FETCH 25 from test;
>> COMMIT;
>>
>> inside psql everything works well. If I put this code into a
>> scriptfile and call it, I get the following errormessage:
>>
>> cannot handle multiple result groups
> Sure seems like whatever database client you're using doesn't really
> support transactions.
I'm guessing that the client-side library thinks the above is a single
SQL statement, and so it's surprised when two result sets (the SELECT
and then the FETCH) come back. This is probably due to misuse of the
library API, but without any details it's hard to offer advice.
regards, tom lane
Hi Bill and Tom Thank you for the hints. I think you pointed me in the right direction. Regards Conni
On Sunday 22 February 2004 21:11, Gyorgy Molnar wrote: > Greetings, > > I have a Linux RedHat 9.0 computer. It has 1G memory. Is there anybody who > could help me to fine tune the Kernel for PgSql, and also the with the > proper settings for the PgSql server. I have two additional java program > running on that computer, otherwise I used a custom installation with the > minimal neccessary packages (No X-Server is initalled). Well, you should probably read the tuning and configuration docs at: http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php Then, post your main config settings to the -performance list along with details of any problems you are seeing. Bear in mind that "best" performance depends on what queries you are executing, so optimising for one group of queries may involve trade-offs with others. -- Richard Huxton Archonet Ltd
>>>>> "g" == greg <greg@turnstep.com> writes: g> A new version of DBD::Pg is about to be released (1.32), and we need g> your help to test it out. If you use DBD::Pg, please download g> and test the latest release candidate. At the very least, running Has my recent bug report on rt.cpan.org been addressed? I never got any ack that it was. See https://rt.cpan.org/NoAuth/Bug.html?id=4996 It was most fun tracking that one down! I'll dl and test 1.32 tomorrow... EOD here now. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Has my recent bug report on rt.cpan.org been addressed? I never got > any ack that it was. See I tried but could not duplicate that bug when it first came out. I don't know if others have tried it out or not, but if you could test with 1.32_2 that would be great. If the bug still exists, please let us know as soon as possible so we can get the fix into 1.32. Thanks, - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200402241922 -----BEGIN PGP SIGNATURE----- iD8DBQFAO+savJuQZxSWSsgRAkUPAKDOk5U2vGy+R1dYgsX4S11Z+oOiBwCfStV0 LBl35tbjd1YzWDH07LMYeeY= =EeQP -----END PGP SIGNATURE-----
Will somebody on this list, hopefully the list manager, tell me how to unsubscribe to this list? In attempting to sent a request for this to "majordomo-owner@postgresql.org" , I got this response: >>>>>>>> unregister jeff.holle@verizon.net >>>> >>>> ---- The unregister command did not succeed. ---- ---- The request ---- "unregister jeff.holle@verizon.net" ---- must be confirmed. Confirmation instructions have been mailed to ---- jeff.holle@verizon.net in a separate message. ---- 1 valid command processed; it is pending. Regretably, I didn't get the promised seperate message, hense I'm still receiving messages.
Well, I'm not seeing Perl core as I did with the previous released version, so it's a step in the right direction. I re-loaded a 2.4 million record db using DBD::Pg with no problems, and am running through the rest of my scripting operations on that db using about .75 million records, with no problems so far. I'll know more tomorrow evening. Other scripts are showing no ill effects yet. using Perl 5.8.1 i386-linux-thread-multi DBI 1.40 PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 (Mandrake Linux 9.1 3.2.2-3mdk) Later, Rob When grilled further on (Sun, 22 Feb 2004 12:33:34 -0000), greg@turnstep.com confessed: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > your help to test it out. If you use DBD::Pg, please download > and test the latest release candidate. At the very least, running -- 22:12:34 up 10 days, 5:53, 3 users, load average: 2.87, 2.53, 2.20 Linux 2.4.21-0.13_test #60 SMP Sun Dec 7 17:00:02 MST 2003
Attachment
On Wednesday 25 February 2004 02:36, Jeff Holle wrote: > Will somebody on this list, hopefully the list manager, tell me how to > unsubscribe to this list? > > In attempting to sent a request for this to > > "majordomo-owner@postgresql.org" , I got this response: > >>>>>>>> unregister jeff.holle@verizon.net I think "unsubscribe" is what you needed here, however, I use the webmail interface for my admin tasks: http://webmail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org -- Richard Huxton Archonet Ltd