DBD::Pg 1.32 ready for testing

[greg]

-----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.postg resql.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.c om
PGP Key: 0x14964AC8 200402200653

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

iD8DBQFANfYrvJu QZxSWSsgRAuQIAK CAWz+yHdkDo4VWO LPo0pJUX3SU9ACg 0DAn
E1FHuzdOtuhJcr1 ySIoSKIk=
=Yps3
-----END PGP SIGNATURE-----


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

[Cornelia Boenigk]

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(`tes t`,`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*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Bill Moran]

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(`tes t`,`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*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Gyorgy Molnar]

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

[Tom Lane]

Bill Moran <wm****@potenti altech.com> writes:

Cornelia Boenigk wrote:

BEGIN;
SELECT cursorname(`tes t`,`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 YourEmailAddres sHere" to ma*******@postg resql.org)

[Cornelia Boenigk]

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

[Richard Huxton]

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

[Vivek Khera]

>>>>> "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.c om Rockville, MD [phone] 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

[Greg Sabino Mullane]

-----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.c om
PGP Key: 0x14964AC8 200402241922
-----BEGIN PGP SIGNATURE-----

iD8DBQFAO+savJu QZxSWSsgRAkUPAK DOk5U2vGy+R1dYg sX4S11Z+oOiBwCf StV0
LBl35tbjd1YzWDH 07LMYeeY=
=EeQP
-----END PGP SIGNATURE-----

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

[Jeff Holle]

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.or g" , I got this response:

>>>> unregister je********@veri zon.net

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