Chris,
On 2012-02-01 17:32, Chris Travers wrote: > On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades <[email protected] > [8]> wrote: > >> Chris, >> >> On 2012-02-01 14 [1]:02, Chris Travers wrote: >> >>> On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades >> <[email protected] [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 Thanks, Phil. -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: [email protected] ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
