Hi there,
well, maybe I'm not total PgSQL noob, but I rather ask here if my
weekend Google-Fu skills are weak and problem is trivial. My problem
is like that: I took over old project by my ex employer and wanted to
clean it a bit. I realized that installer would be a good way to
resolve copy-and-edit-configuration-file approach. I hacked installer
and got myself into I-rule-mode.
All was fun and good before other company told me they can't install it.
This project relies on tsearch code. Installer hits you should have
tsearch2.sql used over your new database or on template1. On my server
CREATE DATABASE gets functions from template1 and everything works. I
assumed it will be same story for them.
But it wasn't. I run:
%apt-cache show postgresql-8.1 | grep Version
Version: 8.1.8-1~bpo.1
And they have PostgreSQL from same branch (ie. 8.1) but a little older
revision. And their tsearch2.sql and mine tsearch2.sql is different!
It gets different order and number of params, IIRC.
Is this possible? Or am I blind or unaware of something? I never had
to admin PostgreSQL database so I feel lost. :-)
If tsearch2.sql changes over versions of PgSQL, what is the best
scenario of managing installer development for PgSQL-enabled projects?
Should I wrap function calls in my own functions? Help, help! I'm
being repressed! :-)