Chris,
On 2012-02-04 12:01, Chris Travers wrote: > On Fri, Feb 3, 2012 at 7:32 AM, Philip Rhoades <p...@pricom.com.au > [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 go back to running the script -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au -- Philip Rhoades GPO Box 3411 Sydney NSW 2001 Australia E-mail: p...@pricom.com.au ------------------------------------------------------------------------------ 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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
