Trouble with pg_encoding_to_char

Started by Nonameover 23 years ago2 messages

youenn.ballouard2@etud.univ-ubs.fr

over 23 years ago

Hi,

I've been developing a program with the postgres jdbc 2 driver, jdk-1.3.0 and
postgres 6.5.

When I start my program up it bombs like so:

Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: ERROR: No such
function 'pg_encoding_to_char' with the specified attributes

Stack Trace:

java.sql.SQLException: ERROR: No such function 'pg_encoding_to_char'
with the specified attributes

at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.Connection.ExecSQL(Connection.java:381)
at org.postgresql.Connection.openConnection(Connection.java:314)
at org.postgresql.Driver.connect(Driver.java:149)

Does anyone know what any of this means...?

Regards,
Youenn

--------------------------------------------------------------------------------
Universitï¿½ de Bretagne sud http://www.univ-ubs.fr/

Barry Lind

barry@xythos.com

over 23 years ago

In reply to: Noname (#1)

Re: Trouble with pg_encoding_to_char

It means you are running a jdbc driver from 7.2 (perhaps 7.1, but I
think 7.2) against a 6.5 database. While we try to make the jdbc driver
backwardly compatable, we don't go back that far. You really should
consider upgrading your database to something remotely current.

thanks,
--Barry

youenn.ballouard2@etud.univ-ubs.fr wrote:

Show quoted text

Hi,

I've been developing a program with the postgres jdbc 2 driver, jdk-1.3.0 and
postgres 6.5.

When I start my program up it bombs like so:

Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: ERROR: No such
function 'pg_encoding_to_char' with the specified attributes

Stack Trace:

java.sql.SQLException: ERROR: No such function 'pg_encoding_to_char'
with the specified attributes

at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.Connection.ExecSQL(Connection.java:381)
at org.postgresql.Connection.openConnection(Connection.java:314)
at org.postgresql.Driver.connect(Driver.java:149)

Does anyone know what any of this means...?

Regards,
Youenn

--------------------------------------------------------------------------------
Universitï¿½ de Bretagne sud http://www.univ-ubs.fr/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org