On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades <p...@pricom.com.au> wrote:
> Chris,
>
>
> On 2012-02-01 14:02, Chris Travers wrote:
> > On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades <p...@pricom.com.au
> > [6]> wrote:
> >
> >> Chris,
> >>
> >> On 2012-02-01 13 [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?
If so, you will need to try this (first on ext_test, and then if successful
on template1):
CREATE EXTENSION tablefunc FROM unpackaged;
DROP EXTENSION tablefunc;
If that seems to work, repeat the create extension test before repeating
the two commands above in template1.
Best Wishes,
Chris Travers
>
> - same as before . .
>
> 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
>
------------------------------------------------------------------------------
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
