使用plperl进行数据库访问 [英] Database accesss using plperl
问题描述
我已经安装了我的PostgreSQL 7.4.2服务器，但是根据我在文档第39.3章中所理解的
，您无法访问数据库
没有DBD： ：PgSPI。根据该模块的自述文件，它只会在不受信任的plperlu上运行。
这是运行查询的唯一方法（SELECT，INSERT，更新）使用
plperl？
运行
不可信语言时需要注意的后果和注意事项？
-
罗伯特
--------------------- ------（广播结束）---------------------------
提示4：唐''''杀'-9''邮政局长
I have plperl installed my PostgreSQL 7.4.2 server, but from what I
understand in chapter 39.3 of the docs, you cannot access the databases
without DBD::PgSPI. According to the readme for that module, it will
only run on the untrusted plperlu.
Is this the only way to run queries (SELECT, INSERT, UPDATE) using
plperl?
What are the consequences and things to look out for when running
untrusted languages?
--
Robert
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
推荐答案
16/06 / 2004 21:27 Robert Fitzpatrick写道：
On 16/06/2004 21:27 Robert Fitzpatrick wrote:
我有plperl安装了我的PostgreSQL 7.4.2服务器，但是根据我在文档的第39.3章中所理解的，你无法访问数据库
这是使用
plperl运行查询（SELECT，INSERT，UPDATE）的唯一方法？
I have plperl installed my PostgreSQL 7.4.2 server, but from what I
understand in chapter 39.3 of the docs, you cannot access the databases
without DBD::PgSPI. According to the readme for that module, it will
only run on the untrusted plperlu.
Is this the only way to run queries (SELECT, INSERT, UPDATE) using
plperl?
您是在谈论在PERL中编写函数/存储过程还是从PERL程序访问数据库的
，因为您已阅读的内容是
特定于函数/存储过程。 （对不起/缺席
标点符号，但我只是在慷慨数量后从酒吧回来了
老斑点母鸡）
-
Paul Thomas
+ ----------------------- ------- + ------------------------------------------ --- +
| Thomas Micro Systems Limited |软件解决方案
商业|
|计算机顾问|
http：//www.thomas-micro -systems-ltd.co.uk |
+ ---------------------------- - + + ---------------------------------------------
---------------------------（广播结束）------- --------------------
提示8：解释分析是你的朋友
Are you talking about writing functions/stored procedures in PERL or
accessing the database from a PERL program because what you have read is
specific to functions/stored procedures. (sorry for the bad/absent
punctuation but I''ve just come back from the pub after a generous quantity
of Old Speckled Hen)
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
16/06/2004 21:27 Robert Fitzpatrick写道：
On 16/06/2004 21:27 Robert Fitzpatrick wrote:
我有plperl安装了我的PostgreSQL 7.4.2服务器，但是我从<在文档的第39.3章中理解，如果没有DBD :: PgSPI，则无法访问数据库。根据该模块的自述文件，它将仅在不受信任的plperlu上运行。
这是使用
plperl运行查询（SELECT，INSERT，UPDATE）的唯一方法？
I have plperl installed my PostgreSQL 7.4.2 server, but from what I
understand in chapter 39.3 of the docs, you cannot access the databases
without DBD::PgSPI. According to the readme for that module, it will
only run on the untrusted plperlu.
Is this the only way to run queries (SELECT, INSERT, UPDATE) using
plperl?
您是在谈论在PERL中编写函数/存储过程还是从PERL程序访问数据库的
，因为您已阅读的内容是
特定于函数/存储过程。 （对不起/缺席
标点符号，但我只是在慷慨数量后从酒吧回来了
老斑点母鸡）
-
Paul Thomas
+ ----------------------- ------- + ------------------------------------------ --- +
| Thomas Micro Systems Limited |软件解决方案
商业|
|计算机顾问|
http：//www.thomas-micro -systems-ltd.co.uk |
+ ---------------------------- - + + ---------------------------------------------
---------------------------（广播结束）------- --------------------
提示8：解释分析是你的朋友
Are you talking about writing functions/stored procedures in PERL or
accessing the database from a PERL program because what you have read is
specific to functions/stored procedures. (sorry for the bad/absent
punctuation but I''ve just come back from the pub after a generous quantity
of Old Speckled Hen)
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
在2004年6月16日星期三19:05，Paul Thomas写道：
On Wed, 2004-06-16 at 19:05, Paul Thomas wrote:
On 16/06/2004 21:27 Robert Fitzpatrick写道：
On 16/06/2004 21:27 Robert Fitzpatrick wrote:
我有plperl安装了我的PostgreSQL 7.4.2服务器，但是根据我在文档的第39.3章中所理解的，你不能访问数据库
没有DBD :: PgSPI。根据该模块的自述文件，它将仅在不受信任的plperlu上运行。
这是使用
plperl运行查询（SELECT，INSERT，UPDATE）的唯一方法？
I have plperl installed my PostgreSQL 7.4.2 server, but from what I
understand in chapter 39.3 of the docs, you cannot access the databases
without DBD::PgSPI. According to the readme for that module, it will
only run on the untrusted plperlu.
Is this the only way to run queries (SELECT, INSERT, UPDATE) using
plperl?
您是在谈论在PERL中编写函数/存储过程还是从PERL程序访问数据库，因为您所阅读的内容是针对函数/存储过程。 （对不起/缺席
标点符号，但我刚从酒吧回来后，大量的老斑点母鸡）
Are you talking about writing functions/stored procedures in PERL or
accessing the database from a PERL program because what you have read is
specific to functions/stored procedures. (sorry for the bad/absent
punctuation but I''ve just come back from the pub after a generous quantity
of Old Speckled Hen)
我在谈论使用Perl编写PostgreSQL存储过程
通过查询访问数据库（如pl / pgsql，也许使用DBI：Pg）
SELECTs ，INSERT，UPDATE等。
-
Robert
------------ ---------------（播出结束）---------------------------
提示9：如果您的
加入列的数据类型不匹配，计划员将忽略您选择索引扫描的愿望
I''m talking about writing PostgreSQL stored procedures using Perl that
access the database via queries (like pl/pgsql, maybe using DBI:Pg) for
SELECTs, INSERTs, UPDATEs, etc.
--
Robert
---------------------------(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
这篇关于使用plperl进行数据库访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
