Ask a Question related to PostgreSQL / PGSQL, Design and Development.
-
Karl Denninger #1
Problem resolved (tsearch2 inhibiting migration)
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 and indices, but that's not a big deal.
All fixed... thanks to the pointer to the OID issue, that got me on the
right track.
--
--
Karl Denninger (karl@denninger.net) Internet Consultant & Kids Rights Activist
[url]http://www.denninger.net[/url] My home on the net - links to everything I do!
[url]http://scubaforum.org[/url] Your UNCENSORED place to talk about DIVING!
[url]http://www.spamcuda.net[/url] SPAM FREE mailboxes - FREE FOR A LIMITED TIME!
[url]http://genesis3.blogspot.com[/url] Musings Of A Sentient Mind
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Karl Denninger Guest
-
Eeek! Major problem after reload with tsearch2
This is know issue with OIDS. You,probably, needed to apply regprocedure_7.4.patch.gz patch from... -
[sfpug] Basic problem installing TSearch2 (full text
Jon, Are you sure your locale is SQL_ASCII and not en_US? --Josh ---------------------------(end of broadcast)---------------------------... -
Basic problem installing TSearch2 (full text search)
Hi all, I've installed TSearch2 with some success- my table now contains a tsvector field that's indexed and I can run full text queries. ... -
Inhibiting Browser Back/Fwd Buttons via PHP?
Is it possible to inhibit the browser Back/Fwd buttons via PHP? Thanks... -
DB2 migration problem
Hello, I am trying to migrate DB2 V5.2 (fp17) to V7.2 (fp10) on AIX 4.3, but keep getting the following error:...



Reply With Quote

