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
- 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
