Thread: Trouble with pg_encoding_to_char

Trouble with pg_encoding_to_char

From
youenn.ballouard2@etud.univ-ubs.fr
Date:
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/



Re: Trouble with pg_encoding_to_char

From
Barry Lind
Date:
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:
> 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
>