Perl "with-perl" configuration option

[John Gibson]

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*******@postg resql.org

[Joshua D. Drake]

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*******@postg resql.org

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - jd@commandpromp t.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

[dj trombley]

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 YourEmailAddres sHere" to ma*******@postg resql.org)

[Keith C. Perry]

Quoting dj trombley <dt***@bumba.ne t>:

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 YourEmailAddres sHere" to ma*******@postg resql.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*******@postg resql.org