On Fri, Feb 3, 2012 at 7:32 AM, Philip Rhoades
<..hidden..> 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.
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 doesn't look like the cleanup is perfect.
Best Wishes,
Chris Travers
> I think we are going to have to walk through drop stuff, create
> extension, until it works. However, dont create the extension on
> template1.
Thanks,
Phil.
--
Philip Rhoades
GPO Box 3411
Sydney NSW 2001
Australia
E-mail:
..hidden..
------------------------------------------------------------------------------
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