On 2012-02-05 02:35, Chris Travers wrote:
> On Sat, Feb 4, 2012 at 7:32 AM, Chris Travers
> > wrote:
>> On Sat, Feb 4, 2012 at 7:25 AM, Philip Rhoades <..hidden..
>> > wrote:>>> LINE 5: FROM (connectby(menu_node::text, id::text,
>>> 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
>>> parent::t...-bash-4.2$ dropdb ext_test
>>> 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$ createdb ext_test
-bash-4.2$ psql ext_test
ext_test=# CREATE EXTENSION connectby;
ERROR: could not open extension control file
"/usr/share/pgsql/extension/connectby.control": No such file or
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>> BEST WISHES,
>> probably take it up tomorrow night. (I could email you my ssh key
>> if you need it).
>> Chris Travers > Of course if we arent to that point I would be happy to keep helping
>>>> I will probably look at documenting this since it may bite
>>> > people. I am wondering if this was restored from an update.
>>> > 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.
>>> Philip Rhoades
> 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 . .
GPO Box 3411
Sydney NSW 2001
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!
Ledger-smb-users mailing list