Chris,
On 2012-02-05 02:35, Chris Travers wrote:
> On Sat, Feb 4, 2012 at 7:32 AM, Chris Travers
> <
..hidden..
> [2]> wrote:
>
>> On Sat, Feb 4, 2012 at 7:25 AM, Philip Rhoades <
..hidden..
>> [1]> wrote:
>>
>>> Chris,
>>>
>>> On 2012-02-05 00:19, Chris Travers wrote:
>>> > so drop tablefunc_crosstab_2, tablefunc_crosstab_3, and
>>> > tablefunc_crosstab_4 from template1.
>>>
>>> Did that as we went before . .
>>>
>>> > Then you should be good.
>>>
>>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>>> "menu_acl_pkey" for table "menu_acl"
>>> ERROR: function connectby(text, text, text, text, text,
>>> integer, text)
>>> does not exist
>>> LINE 5: FROM (connectby(menu_node::text, id::text,
>>> parent::t...
>>> ^
>>> HINT: No function matches the given name and argument types.
>>> You might
>>> need to add explicit type casts.
>>> ERROR: current transaction is aborted, commands ignored until
>>> end of
>>> transaction block
>>> ERROR: c . .
>>
>> Can you successfully create extension in a new database?
-bash-4.2$ dropdb ext_test
-bash-4.2$ createdb ext_test
-bash-4.2$ psql ext_test
psql (9.1.2)
ext_test=# CREATE EXTENSION connectby;
ERROR: could not open extension control file
"/usr/share/pgsql/extension/connectby.control": No such file or
directory
ext_test=#
It's the tablefunc extension. That provides connectby().
>> I know you say you need to get this up shortly. If we cant resolve
>> it like this I could open a paid support case for you. I could
>> probably take it up tomorrow night. (I could email you my ssh key
>> if you need it).
>>
>> BEST WISHES,
>> Chris Travers
>>
>>>> I will probably look at documenting this since it may bite
>>> other
>>> > people. I am wondering if this was restored from an update.
>>> If
>>> > not, I wonder if something crazy is going on with the package
>>> you are
>>> > using. On the latter, I suppose only time will give us a
>>> pattern of
>>> > other failures.
>>>
>>> Thanks,
>>>
>>> Phil.
>>> --
>>> Philip Rhoades
>
> Of course if we arent to that point I would be happy to keep helping
> you out this way too.
It is starting to be too hard/slow - maybe my best option is to set up
a virtual Fedora 16 x86_64 machine and install there and worry about
re-integrating into my production machine sometime later? Then, at
least, I could start getting the accounting done . .
Thanks,
Phil.
--
Philip Rhoades
GPO Box 3411
Sydney NSW 2001
Australia
E-mail:
..hidden..
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
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-dev2
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users