Oleg Bartunov <oleg@sai.msu.su> writes:
> Sorry, I meant when we use contrib module, for example 'tsearch',
> it creates functions, defines op_classes for 'gist_txtidx_ops',
> which use OID of that functions.
> pg_dump doesn't dumps op_clasess and it's impossible to use pg_restore.
So the real gripe is that pg_dump doesn't dump user-defined opclasses.
That's a fair complaint. Submit a patch ;-)
There was talk a little while back of developing an SQL command to
define opclasses, so you wouldn't have to poke the system catalogs
directly. It'd probably be better to implement that and then fix
pg_dump to emit that command than to make pg_dump emit catalog-poking
commands ... but of course it'd be a lot more work.
regards, tom lane