Re: a: queries across databases b: plperl - Mailing list pgsql-novice

Well, I need something like this too, however I had just been planning to
make a 2nd connection to the other database and shuffle a little amount
(<1kB) of data between the two that way.

Anyone know if there is a way to assign an element to a schema AFTER
creation?
I was thinking "INSERT INTO SCHEMA schema {TABLE | FUNCTION | etc.} element"
would be most logical...

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Wayne M. Syvinski
> Sent: Sunday, August 17, 2003 4:11 PM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] a: queries across databases b: plperl
>
>
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>