Обсуждение: 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
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
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
-----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 PostgresI 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_ClickNumber: -2147467259On the Linux console I get:ERROR: Function: 'pg_client_encoding()' does not existUnable to identify a function that satisfies the given argument typesYou 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.