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

[Philip Rhoades <..hidden..>]

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