DBD :: Pg 1.32准备测试 [英] DBD::Pg 1.32 ready for testing
问题描述
----- BEGIN PGP签名消息-----
哈希：SHA1
新版DBD： ：Pg即将发布（1.32），我们需要
你的帮助来测试它。如果你使用DBD :: Pg，请下载
并测试最新的候选版本。至少，运行
make test并报告任何问题都会有很大帮助。
最新版本可以在这里找到：
http://backpan.cpan.org/authors/id/R/RU/RUDY/
目前最新的是DBD-Pg-1.32_2.tar.gz。但是请检查
目录以查看是否有更新的东西。
您可以随时通过cvs获取最新的正在进行的工作
使用anonymous密码登录并使用：
：pserver：an ******* @ gborg.postgresql.org:/usr/local/cvsroot/dbdpg
您可以找到有关该项目的更多信息，提交
错误或功能请求，并在以下位置了解邮件列表：
http://gborg.postgresql.org/project/dbdpg/
- -
Greg Sabino Mullane gr**@turnstep.com
PGP密钥：0x14964AC8 200402200653
-----开始PGP签名-----
iD8DBQFANfYrvJuQZxSWSsgRAuQIAKCAWz + yHdkDo4VWOLPo0p JUX3SU9ACg0DAn
E1FHuzdOtuhJcr1ySIoSKIk =
= Yps3
----- END PGP SIGNATURE -----
---------------------------（广播结束）---------- -----------------
提示1：订阅和取消订阅命令转到毫安******* @ postgresql.org
-----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
推荐答案
大家好吧
我定义了一个返回refcursor的函数。
CREATE FUNCTION cursorname（refcursor，字符变化，字符
变化）RETURNS refcursor ...
使用用户名和serachphrase进行选择。
如果我打电话
BEGIN;
SELECT cursorname（`test`，`username`，`searchphrase` ）;
MOVE 10 in test;
FETCH 25来自测试;
COMMIT;
在psql里面一切正常。如果我将此代码放入
脚本文件并调用它，我会得到以下错误消息：
无法处理多个结果组
为什么？这是什么意思？
我使用的网络服务器与
数据库有一个持久连接。执行脚本连接中断。尝试做一个
回滚数据库返回
进度中没有交易。
欢迎任何帮助
问候
Conni
---------------------- -----（广播结束）---------------------------
提示3：如果发布/通过Usenet阅读，请发送适当的
subscribe-nomail命令到 ma ****** *@postgresql.org ，以便您的
消息可以干净地进入邮件列表
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
Cornelia Boenigk写道：
Cornelia Boenigk wrote:
大家好我
我定义了一个返回refcursor的函数。
CREATE FUNCTION cursorname（refcursor，character varying，character
） ）RETURNS refcursor ...
使用用户名和serachphrase进行选择。
如果我打电话
BEGIN;
SELECT cursorname（`test` ，`username`，`searchphrase`）;
在测试中移动10 t;
FETCH 25来自测试;
COMMIT;
在psql里面一切正常。如果我将此代码放入
脚本文件并调用它，我会得到以下错误消息：
无法处理多个结果组
为什么？这是什么意思？
我使用的网络服务器与
数据库有一个持久连接。执行脚本连接中断。尝试回滚数据库会返回
进度中没有交易。
欢迎任何帮助
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
当然，您所使用的数据库客户端似乎并非真正支持b $ b支持交易。是否有可能每个SQL命令都是以unchained的形式单独发布给后端的。模式？您可能需要
来提供列表，其中包含Postgres客户端的一些详细信息，您将使用它以及如何使用它。然后，有经验的客户可以提出具体的建议。
-
Bill Moran
潜在技术
http://www.potentialtech.com
---------------------------（广播结束）----------- ----------------
提示3：如果通过Usenet发布/阅读，请发送适当的
subscribe-nomail命令 ma*******@postgresql.org 以便您的
消息可以干净利落地到达邮件列表
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
问候，
我有一台Linux RedHat 9.0计算机。它有1G内存。是否有人可以帮助我微调PgSql的内核，以及为PgSql服务器设置适当的
设置。我在该计算机上运行了两个额外的java程序
，否则我使用了一个带有
最小必需程序包的自定义安装（没有X-Server是initalled）。
我读了doccentation，还有Bruce Momjian的PostgreSQL硬件性能调优
。
他们两个都非常有用的，我可以设法提出
配置。一切正常，但我不确定我是否选择了
最佳设置。
提前谢谢。
亲切的问候，
Yuri
ps。我差点忘了;我需要同时使用64个连接，并且最大
记录长度为1024字节。
--------------- ------------（广播结束）---------------------------
提示5：您是否检查了我们广泛的常见问题解答？
http://www.postgresql.org/docs/faqs/FAQ.html
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
这篇关于DBD :: Pg 1.32准备测试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
