Chris,
On 2012-02-02 01:48, Chris Travers wrote: > On Wed, Feb 1, 2012 at 4:40 AM, Philip Rhoades <p...@pricom.com.au > [9]> wrote: > >> Chris, >> >> On 2012-02-01 17 [1]:32, Chris Travers wrote: >> > On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades >> <p...@pricom.com.au [2] >> > [8]> wrote: >> > >> >> Chris, >> >>>> >> >> On 2012-02-01 14 [3] [1]:02, Chris Travers wrote: >> >> >> >>> On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades >> >> <p...@pricom.com.au [4] [2] >> >> > [6]> wrote: >> >> > >> >> >> Chris, >> >>>> >> >>>> >> >> >> On 2012-02-01 13 [3] [1]:21, Chris Travers wrote: >> >> >> > Hi Philip; >> >> >> > >> >> >> > Something is obviously not as expected here. 1.3.10 >> >> addresses >> >> >> issues >> >> >> > of missing extensions directories by detecting the >> PostgreSQL >> >> >> server >> >> >> > version and if it is 9.0 or lower, it tries to look for the >> >> >> > tablefunc.sql, but if it is 9.1 or above, it looks for >> >> >> > tablefunc.control. If you are running 9.1, and it is >> still >> >> >> doing >> >> >> > this, then something isnt right. Either you arent >> pointing >> >> to >> >> >> the >> >> >> >> >> >>> place where tablefunc.control is located, or something else >> is >> >> >> going >> >> >> > on. >> >> >> > >> >> >> > I will be responding to the database troubleshooting steps >> on >> >> the >> >> >> > other thread on -devel. >> >> >> >> >> >> I was doing the RPM testing on a Fedora 16 i686 virtual >> machine >> >> but >> >> >> after those issues were resolved, I moved on to a real >> install >> >> on >> >> >> my >> >> >> live F16 x86_64 which I really need to get going now . . >> >> > >> >> > Try: >> >> > >> >> > select version(); >> >> > >> >> > and >> >> > >> >> > if 9.1: >> >> > >> >> > CREATE EXTENSION tablefunc; >> >> > >> >> > do that in a new database. >> >> > >> >> > If that works you can drop the database and I will send you >> some >> >> > lines >> >> > to comment out. >> >> >> >> -bash-4.2$ dropdb ext_test >> >> -bash-4.2$ createdb ext_test >> >> -bash-4.2$ psql ext_test >> >> psql (9.1.2) >> >> Type "help" for help. >> >> >> >> ext_test=# select version(); >> >> >> >> >> version >> >> >> > >> > >> > > ------------------------------------------------------------------------------------------------------------- >> >> PostgreSQL 9.1.2 on x86_64-redhat-linux-gnu, compiled by gcc >> >> (GCC) >> >> 4.6.2 20111027 (Red Hat 4.6.2-1), 64-bit >> >> (1 row) >> >> >> >> ext_test=# CREATE EXTENSION tablefunc; >> >> ERROR: type "tablefunc_crosstab_2" already exists >> > >> > Interesting. >> > >> > Is it possible that tablefunc had been loaded into template1 and >> then >> > this was upgraded? >> >> Yes maybe - I had some old unused LSMB DBs (1.2.x?) in my setup and >> in >> the transition from Fedora 14 (Postgresql 8.x?) the data was dumped >> out >> and imported into Fedora 16. >> >> > If so, you will need to try this (first on ext_test, and then if >> > successful on template1): >> > >> > CREATE EXTENSION tablefunc FROM unpackaged; >> >> ext_test=# CREATE EXTENSION tablefunc FROM unpackaged; >> ERROR: function normal_rand(integer, double precision, double >> precision) does not exist > > Something in your PostgreSQL database setup is messed up. I am > going to suggest we take this up on the Pgsql lists because someone > may have a better idea than me (if it were me I would add dummy > functions for all those missing and then drop the extension. I will > be sending an email there. I saw your post and the responses in the PostgreSQL list - this is certainly outside my PostgreSQL experience - I await your more detailed instructions! Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
