Skip site navigation (1) Skip section navigation (2)

Re: problem with restore of functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: problem with restore of functions
Date: 2002-02-22 15:39:25
Message-ID: 17004.1014392365@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-02-22 15:57:36
Subject: Replication direction
Previous:From: Thomas LockhartDate: 2002-02-22 15:21:51
Subject: Re: [PATCHES] Automatic transactions in psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group