Hi Chris,
On Sun, Aug 25, 2013 at 10:20 PM, Chris Bennett <
[email protected]> wrote:
> I noticed when I was running tests and writing a script I have been
> working on that the contrib files for OpenBSD (and another operating
> system that came up a couple of years ago that someone else was using).
>
> I saw that all of the files are named like this:
> /usr/local/share/postgresql/extension/tsearch2--1.0.sql
> /usr/local/share/postgresql/extension/tsearch2--unpackaged--1.0.sql
> /usr/local/share/postgresql/extension/tsearch2.control
>
> not tsearch2.sql, pg_trgm.sql, etc.
>
> I just did a ln -s for the testing.
> But what is the situation with other OS's?
> Is this name change common or just in a few places?
>
I'm guessing the PostgreSQL version you were using back then was lower than
9.1 and you're now using 9.1 or higher? This seems to be part of the name
change that's been going on in PostgreSQL for contrib naming and versioning.
> Does anything need to change to reflect this?
>
Generally, yes: instead of loading the extension file, on 9.1+ you should
use the commands "CREATE EXTENSION <extension name>".
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
