Re: DROP FUNCTION IF EXISTS
От | Magnus Hagander |
---|---|
Тема | Re: DROP FUNCTION IF EXISTS |
Дата | |
Msg-id | 6BCB9D8A16AC4241919521715F4D8BCEA35709@algol.sollentuna.se обсуждение исходный текст |
Ответ на | DROP FUNCTION IF EXISTS (Teodor Sigaev <teodor@sigaev.ru>) |
Ответы |
Re: DROP FUNCTION IF EXISTS
Re: DROP FUNCTION IF EXISTS Re: DROP FUNCTION IF EXISTS |
Список | pgsql-hackers |
> Linux: > > $ echo 'DROP FUNCTION if exists foo(int);' | psql 1c Timing is on. > SET > Time: 197.941 ms > NOTICE: function foo(░) does not exist ... skipping > ERROR: invalid byte sequence for encoding "UTF8": 0x90 > HINT: This error can also happen if the byte sequence does not > match the encoding expected by the server, which is controlled by > "client_encoding". > ERROR: invalid byte sequence for encoding "UTF8": 0x90 > HINT: This error can also happen if the byte sequence does not > match the encoding expected by the server, which is controlled by > "client_encoding". > > > FreeBSD: > % echo 'DROP FUNCTION if exists foo(int);' | psql wow SET > NOTICE: function foo(% > > > Looks like uninitialized pointer... Not being an expert, but to me it looks like the client_encoding being set to UTF8 but the data being sent is something otherthan 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 ;-) //Magnus
В списке pgsql-hackers по дате отправления: