Sirs and Madams:
I have been researching PostgreSQL for some time in anticipation of
migrating my most important application from MSAccess to something
*NIX-based.
I've settled on FreeBSD (love it as a desktop/workstation OS) and am
using PostgreSQL 7.3.3 (compiled from ports collection).
2 things
A. I read in one of my PostgreSQL books that you cannot execute queries
across databases. What I have are several lookup tables that I need to
reference from other databases. Each project requires its own database,
and I don't want to copy those huge tables to each database I am using.
I also have up to 5 project databases going at any one time. Did I
understand wrong, or if I understood right, is there a workaround, or am
I stuck using MySQL for this?
B. I cannot get PostgreSQL to accept plperl as a language. Here's what
I posted to another forum (for which I did not get a satisfactory
answer).
Compiled PostgreSQL 7.3.3. from ports. I didn't know that shared
libraries were required from Perl to use plperl.
So I recompiled Perl 5.8.0 from ports - amended Makefile to allow
threads and shared libraries
(-Dusethreads=y -Duseithreads=y -Duseshrplib=y) (I enabled threads
because I needed them to try something in MySQL)
Then I compiled plperl from ports.
I logged in as root and su to pgsql (postgres user) and type:
CREATE FUNCTION plperl_call_handler() RETURNS opaque AS
'/usr/local/lib/postgresql/plperl.so' LANGUAGE 'C';
This didn't work. I get back <deletia> Undefined symbol
"Perl_sv_2pv_flags".
I ran make again and sent the output to a text file. I checked the
output and it was using the aforementioned version of perl.
Any help is greatly appreciated
--
Wayne M. Syvinski - matthew@techcelsior.com
FreeBSD: A Declaration of Independence from Windows
There ain't a horse that can't be rode,
and there ain't a rider that can't be throwed.
