Re: [GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-04 Thread George Essig
We could decree that a contrib module's script should create a schema and shove everything it makes into that schema. Then DROP SCHEMA CASCADE is all you need to get rid of it. However, you'd probably end up having to add this schema to your search path to use the module conveniently.

[GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-03 Thread Karl Denninger
Got it fixed. As it happens, there's an untsearch2.sql script in the contrib directory. Removing the transaction block around it allowed it to kill all the dregs from the 7.4.x database entries (on 8.0.1) and a subsequent tsearch2.sql was then able to rebuild them. I had to reinsert the columns

Re: [GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-03 Thread Michael Fuhr
On Thu, Feb 03, 2005 at 06:44:55PM -0600, Karl Denninger wrote: As it happens, there's an untsearch2.sql script in the contrib directory. That reminds me: it would be useful if all contributed modules had an unmodule.sql file. That would simplify reloading the module if the definitions

Re: [GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-03 Thread Karl Denninger
On Thu, Feb 03, 2005 at 06:59:55PM -0700, Michael Fuhr wrote: On Thu, Feb 03, 2005 at 06:44:55PM -0600, Karl Denninger wrote: As it happens, there's an untsearch2.sql script in the contrib directory. That reminds me: it would be useful if all contributed modules had an unmodule.sql file.

Re: [GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-03 Thread Tom Lane
Karl Denninger [EMAIL PROTECTED] writes: I agree with this - what would be even better would be a way to create 'subclasses' for things like this, which could then be 'included' easily. We could decree that a contrib module's script should create a schema and shove everything it makes into that

Re: [GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-03 Thread Karl Denninger
On Thu, Feb 03, 2005 at 10:20:47PM -0500, Tom Lane wrote: Karl Denninger [EMAIL PROTECTED] writes: I agree with this - what would be even better would be a way to create 'subclasses' for things like this, which could then be 'included' easily. We could decree that a contrib module's script

Re: [GENERAL] Problem resolved (tsearch2 inhibiting migration)

2005-02-03 Thread Oleg Bartunov
On Thu, 3 Feb 2005, Karl Denninger wrote: On Thu, Feb 03, 2005 at 10:20:47PM -0500, Tom Lane wrote: Karl Denninger [EMAIL PROTECTED] writes: I agree with this - what would be even better would be a way to create 'subclasses' for things like this, which could then be 'included' easily. We could