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
"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
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