By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,525 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Perl "with-perl" configuration option

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a


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

P: n/a

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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.