From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Jasbinder Bali <jsbali(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Shared Objects (Dynamic loading) |
Date: | 2006-08-28 05:05:21 |
Message-ID: | 20060828050521.GA1673@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
On Sun, Aug 27, 2006 at 09:41:39PM -0400, Jasbinder Bali wrote:
> The actual scenario is like my perl code is on one computer and database
> server is on the other computer. The perl code needs to connect to that
> database server residing on a diff computer.
>
> I think client machine should also have DBI module in it. right?
Right. The client machine needs DBI (the database-independent
module), DBD::Pg (the PostgreSQL-specific driver), and libpq (the
PostgreSQL client library).
> Also, how much of a change would it be if i have to migrate my triggers
> and functions written for C to Perl
That depends on how many triggers you have, how elaborate they are,
and how proficient you are at Perl. I tend to use PL/pgSQL for
functions that involve a lot of SQL statements; I use PL/Perl or
PL/Ruby for things like text manipulation that those languages are
good at.
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Harpreet Dhaliwal | 2006-08-28 05:25:51 | Perl language creation failed |
Previous Message | mark | 2006-08-28 04:39:12 | Re: jabber.postgresql.org is up |
From | Date | Subject | |
---|---|---|---|
Next Message | Julian Hagenauer | 2006-08-28 05:09:47 | Re: PostgreSQL unexpectedlly closes the connection |
Previous Message | Jasbinder Bali | 2006-08-28 01:41:39 | Re: Shared Objects (Dynamic loading) |