I need to apply the hier patch (http://gppl.moonbone.ru/) that implements support for the Oracle-style CONNECT BY - START WITH syntax. I wanted to keep using this project's packages because I like them. But I do need to switch out a few of the binaries.
What's the best way to go about this? I was thinking of downloading the PostgreSQL 8.0.3 source and applying the hier patch, then compiling with the same configuration options as were used to build the pgsqlformac binaries. Then I'd switch out the files in /Library/PostgreSQL8/bin/.
Is that a stupid idea?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I need to apply the hier patch (http://gppl.moonbone.ru/) that implements support for the Oracle-style CONNECT BY - START WITH syntax. I wanted to keep using this project's packages because I like them. But I do need to switch out a few of the binaries.
What's the best way to go about this? I was thinking of downloading the PostgreSQL 8.0.3 source and applying the hier patch, then compiling with the same configuration options as were used to build the pgsqlformac binaries. Then I'd switch out the files in /Library/PostgreSQL8/bin/.
Is that a stupid idea?
Not at all, it's probably the best avenue, the configure options are:
./configure --prefix=/Library/PostgreSQL8 --with-openssl --with-rendezvous --with-perl --with-pam --with-krb5 --with-tcl --with-python --disable-static --enable-shared
Let me know how things go!..
Well, I needed to compile with slightly different options for my situation, but it worked out like I hoped.
I wrote some notes on the procedure. Here's an OmniOutliner file with the details:
http://homepage.mac.com/jlamoree/xfer/Patching_PostgreSQL.oo3.zip