From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Paul Ramsey" <pramsey(at)refractions(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Module Portability |
Date: | 2002-08-02 01:37:43 |
Message-ID: | GNELIHDDFBOCMGBFGEFOCEHKCDAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Just use $libdir...
Chris
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Paul Ramsey
> Sent: Friday, 2 August 2002 4:01 AM
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: [HACKERS] Module Portability
>
>
> All this talk of modularity reminds me of a pet peeve: doing
> dump/restore upgrades when your databases include extension functions is
> highly clunky, because extension functions include the fully qualified
> path to the linking library. So, for example
>
> create function geometry_in(opaque)
> RETURNS GEOMETRY
> AS '/opt/pgsql72/lib/contrib/libpostgis.so.0.7'
> LANGUAGE 'c' with (isstrict);
>
> If I do a pg_dumpall on an old database and try to pipe into a new
> database, things can get messy pretty fast. It would be nice if pgsql
> had a 'default library location' which it tried to load linking
> libraries from, in much the same way apache uses libexec. Then my
> definition could just be:
>
> create function geometry_in(opaque)
> RETURNS GEOMETRY
> AS 'libpostgis.so.0.7'
> LANGUAGE 'c' with (isstrict);
>
> Which would be alot more portable across installations. I mean, right
> now I can render my database inoperative just by moving my executable
> installation tree to a new path. Nice.
>
> --
> __
> /
> | Paul Ramsey
> | Refractions Research
> | Email: pramsey(at)refractions(dot)net
> | Phone: (250) 885-0632
> \_
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Curt Sampson | 2002-08-02 03:39:18 | Re: Why is MySQL more chosen over PostgreSQL? |
Previous Message | Christopher Kings-Lynne | 2002-08-02 01:13:06 | Re: getpid() function |