From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Functions in CHECK constraint not getting dumped before |
Date: | 2004-02-05 16:09:13 |
Message-ID: | 40226AA9.8000702@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rajesh Kumar Mallah wrote:
> Tom Lane wrote:
>
>>>It is found that pg_dump does not dump function referred in CHECK
>>>constraint definations before dumping the table defination . As a result
>>>the tables
>>>do not get restored due to lack of defined functions.
>>>
>>>
>>
>>
>>
>>>Is it something that will be worked upon in future ?
>>>
>>>
>>
>>This is fixed in CVS tip.
>>
>>
>
> Yes it did solve that problem.
> another problem that i am facing is during pg_dump i get warning
> like:
This problem was also solved . The problem was that the corruption
was in template1 and i was looking at a different database.
i finally reset the template1 by using methods described in
Adventures in PostgreSQL
Episode 1: Restoring a Corrupted Template1 using Template0 , May 2002
Josh Berkus.
Regds
mallah.
>
> pg_dump: WARNING: owner of function "txtidx_in" appears to be invalid
> pg_dump: WARNING: owner of function "txtidx_out" appears to be invalid
> pg_dump: WARNING: owner of function "qtxt_in" appears to be invalid
> pg_dump: WARNING: owner of function "qtxt_out" appears to be invalid
> pg_dump: WARNING: owner of function "mqtxt_in" appears to be invalid
> pg_dump: WARNING: owner of function "gtxtidx_in" appears to be invalid
> pg_dump: WARNING: owner of function "gtxtidx_out" appears to be invalid
> pg_dump: WARNING: owner of function "gtxtidx_consistent" appears to be
> invalid
> pg_dump: WARNING: owner of function "gtxtidx_compress" appears to be
> invalid
> pg_dump: WARNING: owner of function "gtxtidx_decompress" appears to be
> invalid
> pg_dump: WARNING: owner of function "gtxtidx_penalty" appears to be
> invalid
> pg_dump: WARNING: owner of function "gtxtidx_picksplit" appears to be
> invalid
> pg_dump: WARNING: owner of function "gtxtidx_union" appears to be invalid
> pg_dump: WARNING: owner of function "gtxtidx_same" appears to be invalid
>
> And in the dump there are lines like:
>
>
> REVOKE ALL ON FUNCTION txtidx_in(opaque) FROM PUBLIC;
> REVOKE ALL ON FUNCTION txtidx_in(opaque) FROM "";
> *SET SESSION AUTHORIZATION "103"; <---------------------------------*
> GRANT ALL ON FUNCTION txtidx_in(opaque) TO PUBLIC;
> RESET SESSION AUTHORIZATION;
>
>
> can you pls tell me how to get rid of the warnings and the invalid
> id "103" in pg_proc i dont see any reference to SYSID 103
> in the columns proowner or the acl columns.
>
> Any other places where i should look?
>
>
> Regds
> Mallah.
>
>
>> regards, tom lane
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-02-05 16:27:30 | Re: Proper tool to display graphics? |
Previous Message | Marc G. Fournier | 2004-02-05 16:05:33 | Re: size of mailing lists? |