Yes, I finally found the reference in pg_type.
Thanks for your help!
Regards,
Dirk
Tom Lane wrote:
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
I have now deleted every temp table I know from pg_temp_nnn using your
approach but still can't dump the schema:
pg_dump: schema
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
> I have now deleted every temp table I know from pg_temp_nnn using your
> approach but still can't dump the schema:
> pg_dump: schema with OID 559701082 does not exist
> I could'nt find any reference to 559701082 in pg_class, pg_names
Hi Tom,
I have now deleted every temp table I know from pg_temp_nnn using your
approach but still can't dump the schema:
pg_dump: schema with OID 559701082 does not exist
I could'nt find any reference to 559701082 in pg_class, pg_namespace
or pg_proc.
Regards,
Dirk
Tom Lane wrote:
=?I
I have found and deleted an entry with pg_class.relnamespace=559701082
but nowhere else. I still cannot dump the schema. Is there something
like a system catalog integrity checker?
The problem I'm facing is the following:
cs1=# select relname from pg_class where relname like 'bm%';
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
> Yes, I think so. What search path do you mean? These tables were all
> temporary tables.
In that case they're most likely *not* in your search path, unless your
session happens to have seized on the same pg_temp_nn schema they are
in
Yes, I think so. What search path do you mean? These tables were all
temporary tables.
Dirk
Tom Lane wrote:
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
The problem I'm facing is the following:
cs1=# select relname from pg_class where relname like 'bm%';
r
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
> The problem I'm facing is the following:
> cs1=# select relname from pg_class where relname like 'bm%';
>relname
> ---
> bm_pagehits_1133271374_047421_941
> bm_pagehits_1133271378_92
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:
> I get the following error when I call:
> # pg_dump db
> pg_dump: schema with OID 559701082 does not exist
I suspect a corrupted catalog entry. Look through your system catalogs
for an entry referring to namespace 559701082 --- you w
Hi,
I get the following error when I call:
# pg_dump db
pg_dump: schema with OID 559701082 does not exist
this happens with 8.0.1 on RHEL 3.0. I cannot dump the database neither
with --schema-only or --data-only.
What can I do?
Thanks for help,
Dirk
---(end of bro
