Re: [GENERAL] Problem with to_tsquery() after restore on PostgreSQL 9.0.1

2010-11-11 Thread Markus Wollny
Hi! Tom Lane writes: > So far as I can see offhand, the only way you'd get that error message > is if to_tsquery were declared to take OID not regconfig as its first > argument. > > > I suspect it has to do with the Tsearch2-compatibility modules from > > contrib - these were compiled and insta

Re: [GENERAL] Problem with to_tsquery() after restore on PostgreSQL 9.0.1

2010-11-10 Thread Tom Lane
"Markus Wollny" writes: > I currently testing the upgrade of our 8.3 databases to 9.0. > In some of those restored databases to_tsquery is throwing an error: > magazine=# SELECT to_tsquery('simple','plants'); > ERROR: invalid input syntax for type oid: "simple" So far as I can see offhand, the

[GENERAL] Problem with to_tsquery() after restore on PostgreSQL 9.0.1

2010-11-10 Thread Markus Wollny
Hi! I currently testing the upgrade of our 8.3 databases to 9.0. In some of those restored databases to_tsquery is throwing an error: magazine=# SELECT to_tsquery('simple','plants'); ERROR: invalid input syntax for type oid: "simple" LINE 1: SELECT to_tsquery('simple','plants'); In other datab