Re: [OT][HACKERS] DROP FUNCTION IF EXISTS
Backspace deletes character-wise, as long as you have LANG set correctly. Check LANG and the LC_* environment variables. OK, you're right: $ echo $LANG [EMAIL PROTECTED] # show client_encoding ; client_encoding - UTF8 (1 row) But then I wonder why the client encoding is set to UTF-8 ? I did not fiddle at all with this AFAIK, and I guess psql is the one setting this... OTOH, I'm accessing the DB box via ssh, and my local box has: cnagy echo $LANG en_US.UTF-8 So it might be some strange interaction between my local locale, the server's locale and ssh... BTW, I tried if the same problem happens on the server command line (via ssh), and it does (while, for completeness, it works fine on my local box): [EMAIL PROTECTED]:~$ date -sh: date: command not found ^ this here is the result of 'ü + backspace' So I guess this is not postgres related, and therefore off topic for this list... Cheers, Csaba. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] DROP FUNCTION IF EXISTS
CN == Csaba Nagy [EMAIL PROTECTED] writes: CN The full story is that I typed 'ü' (u-umlaut if it won't render CN correctly) and backspace before the '1'. I guess the backspace CN will delete byte-wise and will so fail to delete properly CN multi-byte characters. Backspace deletes character-wise, as long as you have LANG set correctly. Check LANG and the LC_* environment variables. /Benny ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] DROP FUNCTION IF EXISTS
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... -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] DROP FUNCTION IF EXISTS
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 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 ;-) //Magnus ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] DROP FUNCTION IF EXISTS
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. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] DROP FUNCTION IF EXISTS
Hi, Csaba, Csaba Nagy wrote: 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... I think this could be a problem with libreadline / libedit not being utf8-safe. HTH, Markus -- Markus Schaber | Logical TrackingTracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org signature.asc Description: OpenPGP digital signature
Re: [HACKERS] DROP FUNCTION IF EXISTS
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 ;-) All characters in query are an ANSI. On freebsd encoding of client and server is a KOI8-R, not an UTF. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] DROP FUNCTION IF EXISTS
postgres=# drop type if exists foo; NOTICE: type foo does not exist, skipping DROP TYPE postgres=# drop table if exists foo; NOTICE: table foo does not exist, skipping DROP TABLE postgres=# drop function if exists foo(); NOTICE: function foo() does not exist ... skipping DROP FUNCTION postgres=# drop function if exists foo(int); NOTICE: function foo( ^^^ here psql is stopped.. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] DROP FUNCTION IF EXISTS
Teodor Sigaev wrote: postgres=# drop type if exists foo; NOTICE: type foo does not exist, skipping DROP TYPE postgres=# drop table if exists foo; NOTICE: table foo does not exist, skipping DROP TABLE postgres=# drop function if exists foo(); NOTICE: function foo() does not exist ... skipping DROP FUNCTION postgres=# drop function if exists foo(int); NOTICE: function foo( ^^^ here psql is stopped.. Yes, this appears to be a bug, not related to encoding etc. Maybe we should be calling func_signature_string in generating this error. I will look at it when I get a chance, might be a few days. cheers andrew ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] DROP FUNCTION IF EXISTS
Andrew Dunstan [EMAIL PROTECTED] writes: Yes, this appears to be a bug, not related to encoding etc. Maybe we should be calling func_signature_string in generating this error. Can't, because you don't have an Oid array for the types. TypeNameToString is the correct thing --- I'm considering inventing TypeNameListToString in order to make generating the message simple. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] DROP FUNCTION IF EXISTS
Found a problem: ereport(NOTICE, (errmsg(function %s(%s) does not exist ... skipping, NameListToString(functionName), NameListToString(argTypes; NameListToString() suppose as an argument List of Value nodes, but argTypes is a list of TypeName... Andrew Dunstan wrote: Teodor Sigaev wrote: postgres=# drop type if exists foo; NOTICE: type foo does not exist, skipping DROP TYPE postgres=# drop table if exists foo; NOTICE: table foo does not exist, skipping DROP TABLE postgres=# drop function if exists foo(); NOTICE: function foo() does not exist ... skipping DROP FUNCTION postgres=# drop function if exists foo(int); NOTICE: function foo( ^^^ here psql is stopped.. Yes, this appears to be a bug, not related to encoding etc. Maybe we should be calling func_signature_string in generating this error. I will look at it when I get a chance, might be a few days. cheers andrew -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] DROP FUNCTION IF EXISTS
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Yes, this appears to be a bug, not related to encoding etc. Maybe we should be calling func_signature_string in generating this error. Can't, because you don't have an Oid array for the types. TypeNameToString is the correct thing --- I'm considering inventing TypeNameListToString in order to make generating the message simple. Sounds like a plan. cheers andrew ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster