Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
I face the following problem in transferring data from
pgsql 7.3.4 to pgsql 7.4 RC1 . I am piping the output of
pg_dumpall from 7.3 to 7.4 running on different port.
The problem is there is a gist index on txtidx type on a
non-public schema and when search_path does not include
public the index cannot be created.
There is a post-7.3.4 bug fix in the 7.3 branch for this mistake:
2003-10-02 18:25 tgl
* src/backend/utils/adt/ruleutils.c (REL7_3_STABLE): When dumping CREATE INDEX, must show opclass name if the opclass isn't in the schema search path. Otherwise pg_dump doesn't correctly dump scenarios where a custom opclass is created in 'public' and then used by indexes in other schemas.
Since the bug is in the backend and not pg_dump, you can't escape it by using the 7.4 version of pg_dump against the 7.3 server.
Ok,I read somewhere its always better to use more recent pg_dump while migrating.
You could recompile the server using the 7.3-branch-head version of ruleutils.c,
Thanks for the explanation , Shall do that please tell me how to fetch ruleutils.c
from 7.3-branch-head (do not know the cvs commands O:-) ) , thanks again.
regds mallah.
though.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
