[GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Chris Travers
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; the following occurs: -bash-4.2$ dropdb ext_test -bash-4.2$

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Merlin Moncure
On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers chris.trav...@gmail.com 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

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers chris.trav...@gmail.com 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

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 mmonc...@gmail.com writes: On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers chris.trav...@gmail.com wrote: ext_test=# CREATE EXTENSION tablefunc; ERROR:  type tablefunc_crosstab_2 already exists This lead me to conclude that we needed to

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Tom Lane
Philip Rhoades p...@pricom.com.au 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

Re: [GENERAL] Issue with CREATE EXTENSION tablefuncKreiter

2012-02-01 Thread Chris Travers
On Wed, Feb 1, 2012 at 1:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: Philip Rhoades p...@pricom.com.au 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