473,394 Members | 1,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Perl "with-perl" configuration option

Hi, all.

I read that the "--with-perl" option "Build the PL/Perl server-side
language". Does that mean the the switch is necessary to connect to the
PostgreSQL database if you are using a perl program?

It seems to me that it is only for allowing the use of perl *inside* of
postgres and if one is just using perl programs to access the database
from the outside this switch is not necessary. I want to make sure I
give the applications programmers the tools they need.

Also, does the PL/pgSQL server-side language get built automatically by
default?

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

Nov 12 '05 #1
3 1654


John Gibson wrote:
Hi, all.

I read that the "--with-perl" option "Build the PL/Perl server-side
language". Does that mean the the switch is necessary to connect to
the PostgreSQL database if you are using a perl program?
No. It means that it will install the plPerl procedural language. You
need DBI and DBD::Pg for external Perl access to the database.

Sincerely,

Joshua D. Drake

It seems to me that it is only for allowing the use of perl *inside*
of postgres and if one is just using perl programs to access the
database from the outside this switch is not necessary. I want to
make sure I give the applications programmers the tools they need.

Also, does the PL/pgSQL server-side language get built automatically
by default?

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

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(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 12 '05 #2

No, the --with-perl option builds PL/Perl, which is server-side. I
recommend using the module DBD::Pg for connecting to the server from a
perl script and executing queries, but there are probably other modules
as well.
I read that the "--with-perl" option "Build the PL/Perl server-side
language". Does that mean the the switch is necessary to connect to
the PostgreSQL database if you are using a perl program?

It seems to me that it is only for allowing the use of perl *inside*
of postgres and if one is just using perl programs to access the
database from the outside this switch is not necessary. I want to
make sure I give the applications programmers the tools they need.
Yes, but be sure to CREATE LANGUAGE in your database so you can use it.
Also, does the PL/pgSQL server-side language get built automatically
by default?

-dj
---------------------------(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 12 '05 #3
Quoting dj trombley <dt***@bumba.net>:

No, the --with-perl option builds PL/Perl, which is server-side. I
recommend using the module DBD::Pg for connecting to the server from a
perl script and executing queries, but there are probably other modules
as well.
I read that the "--with-perl" option "Build the PL/Perl server-side
language". Does that mean the the switch is necessary to connect to
the PostgreSQL database if you are using a perl program?

It seems to me that it is only for allowing the use of perl *inside*
of postgres and if one is just using perl programs to access the
database from the outside this switch is not necessary. I want to
make sure I give the applications programmers the tools they need.

Yes, but be sure to CREATE LANGUAGE in your database so you can use it.
Also, does the PL/pgSQL server-side language get built automatically
by default?

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


Just FYI...

Typically the "other" perl module is Pg.pm
(http://gborg.postgresql.org/project/...ojdisplay.php).

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

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

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Maxim Vexler | last post by:
Hello to everyone, Assuming i have this simple script : <?PHP //Opening tag =' $html_header=' <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"...
0
by: RitaG | last post by:
Hi. When I set "Option Strict" to On, I'm getting an error message "Option Strict On disallows implicit conversions from 'System.Object' to 'Outlook.MailItem' with the following code: Dim...
1
by: ouioui | last post by:
Hi, I try to have a communicatition between 2 windows In the first one i have a HTML styled select like that : <form name='addform' id='addform' action='add_dossier.php' method='post' >...
0
by: 4.spam | last post by:
Hello. W2K, DB2 ESE V8.2.1 I created a dummy sql sp that returns 2 result sets. One of cursors inside it I declared as "with hold with return" and another as "with return" (without "with...
0
by: David Mediavilla | last post by:
I am writing a client for an HTTPS web service using WSE 1.0 but I always get an error like "The underlying connection was closed: An unexpected error occurred on a send." Sometimes the error...
1
by: David | last post by:
I am attempting to use "TraceSwitch " in Win Forms (Below is the code and the app.config). According to the manual, the program should read the config for the setting, but this is not occurring....
2
by: Midgard | last post by:
Hi there, I have this codes: <select name="my_items"> <option value="bmw">My Car</option> <option value="audi">My Old Car</option> </select>
8
by: shira | last post by:
I have done a fair bit of searching, but haven't yet been able to find an explanation as to why one would set "ignore nulls" to "yes" when creating an index. I understand what it does (I think),...
35
by: Chris | last post by:
Hi, I tried to create a class which must change the propety 'visible' of a <linktag in the masterpage into 'false' when the user is logged. But i get the error: "Object reference not set to an...
8
by: John Nagle | last post by:
Here's a URL, found in a link, which gives us trouble when we try to follow the link: http://sportsbra.co.uk/../acatalog/shop.html Browsers immediately turn this into ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.