Re: Re: how to clean up temporary schemas (how to sync the system table with pg_dump)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gary Fu <gfu(at)saicmodis(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: how to clean up temporary schemas (how to sync the system table with pg_dump)
Date: 2008-06-06 19:08:58
Message-ID: 28156.1212779338@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gary Fu <gfu(at)saicmodis(dot)com> writes:
> Thanks for the response. Yes, normally it will be okay. However, when
> I tried PgAdmin with Pgpool, it will cause problem. The PgAdmin will
> try to access pg_namespace when making a connection to a db, if the
> temporary schemas are different between the backend db servers,
> the pgpool will return mismatch error and fail the PgAdmin connection.

You'll want to take that up on the pgAdmin lists. Or perhaps it's a
pgpool problem, it's hard to tell with such a sketchy description.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Hunter 2008-06-06 19:10:23 Re: when to reindex?
Previous Message Tom Lane 2008-06-06 18:55:29 Re: intagg memory leak