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(at)gborg(dot)postgresql(dot)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(at)turnstep(dot)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(at)potentialtech(dot)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(at)turnstep(dot)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(at)kciLink(dot)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(at)turnstep(dot)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(at)postgresql(dot)org" , I got this response:

>>>>>>>> unregister jeff(dot)holle(at)verizon(dot)net
>>>>
>>>>
---- The unregister command did not succeed.
----
---- The request
---- "unregister jeff(dot)holle(at)verizon(dot)net"
---- must be confirmed. Confirmation instructions have been mailed to
---- jeff(dot)holle(at)verizon(dot)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.

--Multipart_Tue__24_Feb_2004_22_23_15_-0700_=.35zz(k1utMiN+d
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

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(at)turnstep(dot)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

--Multipart_Tue__24_Feb_2004_22_23_15_-0700_=.35zz(k1utMiN+d
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iEYEARECAAYFAkA8MUMACgkQLQ/DKuwDYzlu5wCfWxoimpKDQGt1JoefBA03/6mK
9MUAoJZ+wD+TSln5NL9vxTwYpwJITPa0
=p/HH
-----END PGP SIGNATURE-----

--Multipart_Tue__24_Feb_2004_22_23_15_-0700_=.35zz(k1utMiN+d--

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(at)postgresql(dot)org" , I got this response:
> >>>>>>>> unregister jeff(dot)holle(at)verizon(dot)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