Perl "with-perl" configuration option

Started by John Gibsonover 22 years ago4 messagesgeneral
Jump to latest
#1John Gibson
gib@edgate.com

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

#2Joshua D. Drake
jd@commandprompt.com
In reply to: John Gibson (#1)
Re: Perl "with-perl" configuration option

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
#3Keith C. Perry
netadmin@vcsn.com
In reply to: John Gibson (#1)
Re: Perl "with-perl" configuration option

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

#4Dave Trombley
dtrom@bumba.net
In reply to: John Gibson (#1)
Re: Perl "with-perl" configuration option

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