Michael Fuhr wrote:
> dbi-link is an alternative to dblink that uses Perl/DBI:
>
> http://pgfoundry.org/projects/dbi-link/
>
> > is this the only way available if additional procedural languages
> > are installed?
>
> With the untrusted version of a language you can do essentially
> anything th
Alvaro Herrera wrote:
> > I'm considering building a .so on a scratch machine and copying it to the
> > production server but I'm not confident that I understand every possible
> > implication.
>
> Or maybe you could install the development Perl package, which at least
> on some distros I know inc
Michael Fuhr wrote:
>
> > The other thing that I'm thinking is that it's quite possible that (as
> > hypothetical examples) PL/Perl, PostGIS and PL/R wouldn't be happy on the
> > same machine, at which point the only way to merge their functionality in
> > complex work would be to use a "farm".
>
> With the untrusted version of a language you can do essentially
> anything that language supports. For example, with plperlu, you
> could use DBI to open a connection to another database (even another
> DBMS like Oracle, MySQL, etc.), issue a query, fetch the results,
> and do whatever you want
Mark Morgan Lloyd wrote:
> Thanks for that. One of the reasons that I am contemplating this is that when
> I
> built the server it wouldn't build PL/Perl since the underlying distro didn't
> provide a libperl.so file. Now I could obviously recompile the distro's Perl
> sources but that would mean
On Sun, Jul 09, 2006 at 03:00:08PM +, Mark Morgan Lloyd wrote:
> The other thing that I'm thinking is that it's quite possible that (as
> hypothetical examples) PL/Perl, PostGIS and PL/R wouldn't be happy on the same
> machine, at which point the only way to merge their functionality in complex
On Sun, Jul 09, 2006 at 12:40:56PM +, Mark Morgan Lloyd wrote:
> I know that the FAQ says that the only way to implement a query
> across databases is to use dblink,
The FAQ doesn't say dblink is the only way, it says "contrib/dblink
allows cross-database queries using function calls." Howeve
Merlin Moncure wrote:
>
> > Similarly, if I have PostGIS or PL/R on the hacker's server, or- heaven
> > forfend- both, is the best way to get at the production server still to use
> > dblink?
>
> dblink allows you to send queries from one server to another in a
> couple of different ways. What th
On 7/9/06, Mark Morgan Lloyd <[EMAIL PROTECTED]> wrote:
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does n
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does not have PL/Perl
installed, and a hacker's server B (let's
10 matches
Mail list logo
