Re: DROP FUNCTION IF EXISTS

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP FUNCTION IF EXISTS
Date: 2006-09-25 12:54:41
Message-ID: 1159188881.3874.46.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Not being an expert, but to me it looks like the client_encoding being set to UTF8 but the data being sent is something other than UTF8. I've seen this happen on Linux when connecting with PuTTY from Windows (and then psql from the linux machine) and having the wrong encoding set in PuTTY. I'd double and triple-check the client-side stuff first ;-)

I have seen another strange occurrence of such errors... I'm using linux
with UTF8 client encoding, and psql gives me such errors:

dbval=# select 1;
ERROR: column " 1" does not exist

The full story is that I typed 'ü' (u-umlaut if it won't render
correctly) and backspace before the '1'. I guess the backspace will
delete byte-wise and will so fail to delete properly multi-byte
characters. I have no idea if this is a problem of psql or some other
problem, and it was not annoying enough to report it...

BTW, the space in " 1" is something I was not able to copy-paste from
the psql command line into the mail, so I'm pretty sure it's a byte code
which is invalid UTF8.

Cheers,
Csaba.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Schaber 2006-09-25 13:02:21 Re: DROP FUNCTION IF EXISTS
Previous Message Magnus Hagander 2006-09-25 12:39:58 Re: DROP FUNCTION IF EXISTS