467,161 Members | 840 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

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:an*******@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 gr**@turnstep.com
PGP Key: 0x14964AC8 200402200653

-----BEGIN PGP SIGNATURE-----

iD8DBQFANfYrvJuQZxSWSsgRAuQIAKCAWz+yHdkDo4VWOLPo0p JUX3SU9ACg0DAn
E1FHuzdOtuhJcr1ySIoSKIk=
=Yps3
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 22 '05 #1
  • viewed: 1992
Share:
11 Replies
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #2
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #3
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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #4
Bill Moran <wm****@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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #5
Hi Bill and Tom

Thank you for the hints. I think you pointed me in the right
direction.

Regards
Conni
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #6
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/Gener...bits/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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #7
>>>>> "g" == greg <gr**@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: kh***@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #8

-----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 gr**@turnstep.com
PGP Key: 0x14964AC8 200402241922
-----BEGIN PGP SIGNATURE-----

iD8DBQFAO+savJuQZxSWSsgRAkUPAKDOk5U2vGy+R1dYgsX4S1 1Z+oOiBwCfStV0
LBl35tbjd1YzWDH07LMYeeY=
=EeQP
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 22 '05 #9
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
"ma*************@postgresql.org" , I got this response:
>>>> unregister je********@verizon.net

---- The unregister command did not succeed.
----
---- The request
---- "unregister je********@verizon.net"
---- must be confirmed. Confirmation instructions have been mailed to
---- je********@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.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #10

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),
gr**@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

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

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

Nov 22 '05 #11
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

"ma*************@postgresql.org" , I got this response:
>>>>> unregister je********@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_...postgresql.org
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Pablo S | last post: by
reply views Thread by Envex Developments | last post: by
reply views Thread by Envex Developments | last post: by
reply views Thread by Alex | last post: by
10 posts views Thread by Ausrack Webmaster | last post: by
4 posts views Thread by Patrick Hatcher | last post: by
2 posts views Thread by David Siebert | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.