Re: Error on pgAdminIII 1.2.2 and 1.4.0

From: Keith <keithcelt(at)yahoo(dot)com>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Error on pgAdminIII 1.2.2 and 1.4.0
Date: 2005-10-24 12:50:50
Message-ID: 20051024125050.82597.qmail@web50514.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Andreas,

Your tip about a namespace did the trick. I had
renamed the "public" schema which had caused all of my
problems. I do not understand why. Returning the
schema name to "public" fixed everything.

Thank you,

Keith

--- Andreas Pflug <pgadmin(at)pse-consulting(dot)de> wrote:

> > Whenever I connect to the work server from home
> (but
> > not localhost) I get the following message:
> "Error:
> > pg_postmaster_starttime() does not exist. HINT:
> No
> > function matches the given name and argument
> types.
> > You may need to add explicit type casts."
>
> This is very strange. pgAdmin checks for the
> existence of the function,
> before trying to use it.
> Only reason I could think of is some namespace
> issue. Is
> pg_postmaster_starttime in some exotic schema, while
> pgAdmin expects it
> in public or pg_catalog? Some search_path issue?
>
> Regards,
> Andreas
>



__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-10-24 13:10:20 Re: Backup problem
Previous Message Dr. Harald Fricke 2005-10-24 12:20:18 Re: pgAdmin III 1.2.2 edit grid crashes with single-column