Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Chris Travers
On Wed, Feb 1, 2012 at 1:31 PM, Tom Lane wrote: > Philip Rhoades writes: > > On 2012-02-02 02:52, Tom Lane wrote: > >> Anyway the solution is to connect to template1 and drop any cruft > >> that's lying around in it. > > > I haven't done any manual messing around with template1 as far as I > > k

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Tom Lane
Philip Rhoades writes: > On 2012-02-02 02:52, Tom Lane wrote: >> Anyway the solution is to connect to template1 and drop any cruft >> that's lying around in it. > I haven't done any manual messing around with template1 as far as I > know . . Well, the behavior you describe indicates pretty str

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Philip Rhoades
Tom, On 2012-02-02 02:52, Tom Lane wrote: Merlin Moncure writes: On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers wrote: ext_test=# CREATE EXTENSION tablefunc; ERROR:  type "tablefunc_crosstab_2" already exists This lead me to conclude that we needed to CREATE EXTENSION FROM UNPACKAGED thin

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Tom Lane
Merlin Moncure writes: > On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers wrote: >> ext_test=# CREATE EXTENSION tablefunc; >> ERROR:  type "tablefunc_crosstab_2" already exists >> >> This lead me to conclude that we needed to CREATE EXTENSION FROM UNPACKAGED >> thinking this might be an upgrade iss

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Merlin Moncure
On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers wrote: > Hi all; > > We have gotten a report from a user who is having issues with CREATE > EXTENSION tablefunc.  I figured I would ask for additional insight and > assistance at this point. > > When the user tries to run CREATE EXTENSION tablefunc; th