Thread: 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
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 majordomo@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
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
Quoting dj trombley <dtrom@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 majordomo@postgresql.org) > Just FYI... Typically the "other" perl module is Pg.pm (http://gborg.postgresql.org/project/pgperl/projdisplay.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