[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Announcing LedgerSMB 1.3.10 - hit the wrong key . .



Chris,


On 2012-02-04 12:01, Chris Travers wrote:
On Fri, Feb 3, 2012 at 7:32 AM, Philip Rhoades <..hidden..
[5]> wrote:

Chris,

On 2012-02-02 19:33, Chris Travers wrote:
> Can you create the extension now?

ext_test=# CREATE EXTENSION tablefunc;
ERROR: Âtype "tablefunc_crosstab_3" already exists
ext_test=#

Keep dropping types until it works.Â


template1=# DROP TYPE tablefunc_crosstab_3;
DROP TYPE
template1=# \q

ext_test=# DROP TYPE tablefunc_crosstab_3;
DROP TYPE
ext_test=# CREATE EXTENSION tablefunc;
ERROR:  type "tablefunc_crosstab_4" already exists
ext_test=# DROP TYPE tablefunc_crosstab_4;
DROP TYPE

template1=# DROP TYPE tablefunc_crosstab_4;
DROP TYPE

ext_test=# CREATE EXTENSION tablefunc;
CREATE EXTENSION

- Yay!


Now, looking at the tablefunc install and uninstall scripts, it looks
like this might have happened if tablefunc was installed and then
uninstalled into the template1 database. ÂIt doesnt look like the
cleanup is perfect.


Right but I don't know how I would have done that . .

Do I now go back to running the Pg-database.sql script?

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..

--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..

--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..

--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..

--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..