On Sat, Feb 4, 2012 at 8:59 PM, Philip Rhoades <[email protected]> wrote:
> Chris,
>
>
> On 2012-02-05 02:35, Chris Travers wrote:
> > On Sat, Feb 4, 2012 at 7:32 AM, Chris Travers
> > <[email protected]
> > [2]> wrote:
> >
> >> On Sat, Feb 4, 2012 at 7:25 AM, Philip Rhoades <[email protected]
> >> [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().
Best Wishes,
Chris Travers
>
>
> >> 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: [email protected]
>
>
> ------------------------------------------------------------------------------
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
