Thread: Problem connecting to Postgres

Problem connecting to Postgres

From

"Peter Wilson"

Date:

15 December 2002, 08:02:55

I used pgadmin a while ago with no problems at all - a very useful tool! After one of the upgrades I now cannot connect to my postgres server (which runs on a spearate Linux box). When I try to connect I get an error message from pgadmin:

An error has occured in pgAdminII:frmConnect_Click

Number: -2147467259

On the Linux console I get:

ERROR: Function: 'pg_client_encoding()' does not exist

Unable to identify a function that satisfies the given argument types

You may need to add explicit typecasts

My PC is running Windows 2000

The Linux box is running:

RedHat Linux 7.3

PostgreSQL 7.2.3 - Installed from the standard RPMs

I'm not in a position to upgrade to PostgreSQL 7.3 at this stage.

I've been installing some of the older releases to see when this problem was introduced (and to make sure it's not my database!)

version 1.2.0 : Works fine.

version 1.3.60 : Fails with the error described above

so looks like a problem from version 1.3 onwards.

Any help greatly appreciated!

Peter Wilson

Re: Problem connecting to Postgres

From

Jean-Michel POURE

Date:

15 December 2002, 13:58:18

Le Dimanche 15 Décembre 2002 01:32, Peter Wilson a écrit :
> ERROR: Function: 'pg_client_encoding()' does not exist
>     Unable to identify a function that satisfies the given argument types
>     You may need to add explicit typecasts

This used to work on my Linux box. This may be a problem with the database not
showing system objects.

Cheers,
Jean-Michel

Re: Problem connecting to Postgres

From

"Dave Page"

Date:

15 December 2002, 17:44:07

-----Original Message-----
From: Peter Wilson [mailto:petew@yellowhawk.co.uk]
Sent: 15 December 2002 00:32
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Problem connecting to Postgres

I used pgadmin a while ago with no problems at all - a very useful tool! After one of the upgrades I now cannot connect to my postgres server (which runs on a spearate Linux box). When I try to connect I get an error message from pgadmin:
    An error has occured in pgAdminII:frmConnect_Click
    Number: -2147467259

On the Linux console I get:
ERROR: Function: 'pg_client_encoding()' does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts

Hmm, odd. pgAdmin doesn't use that function - at least not in the current release version, and there is no error message in the source that refers to frmConnect_Click. 1.3.60 is quite an old dev version though, can you try 1.4.12 and if it still doesn't work, recreate the error with logging turned on to full debug and send the pgAdmin and psqlodbc logfiles.

Regards, Dave.