Re: [GENERAL] Procedural language functions across servers

2006-07-10 Thread Mark Morgan Lloyd
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 that

[GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
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

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Merlin Moncure
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

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
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 the

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Michael Fuhr
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. However,

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Michael Fuhr
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

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Alvaro Herrera
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 I'd

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
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 with

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
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. What sort

Re: [GENERAL] Procedural language functions across servers

2006-07-09 Thread Mark Morgan Lloyd
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 include the