Re: [HACKERS] [BUGS] Bug #659: lower()/upper() bug on

2002-05-13 Thread Tatsuo Ishii
> I think it is really not hard to do this for UTF-8. I don't have to know the > relation between the locale and the encoding. Look at this: > We can use the LC_CTYPE from pg_controldata or alternatively the LC_CTYPE > at server startup. For nearly every locale (de_DE, ja_JP, ...) there exists > a

Re: [BUGS] [BUG] COPY ... FROM STDIN hangs where supplied with too many more fields

2002-05-13 Thread Tom Lane
Jean-Luc Lachance <[EMAIL PROTECTED]> writes: > psql -c "COPY table FROM STDIN DELIMITERS ':'" < data.txt > hangs without warning when supplied with more field than the actual > table. Oh? $ psql regression ... regression=# create table tab (f1 int,f2 int); CREATE regression=# \q $ cat data.txt

[BUGS] [BUG] COPY ... FROM STDIN hangs where supplied with too many more fields

2002-05-13 Thread Jean-Luc Lachance
psql -c "COPY table FROM STDIN DELIMITERS ':'" < data.txt hangs without warning when supplied with more field than the actual table. JLL ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[BUGS] bug........HELP

2002-05-13 Thread fereydoun hormozdiari
I have tried to install the new postgreSQL ver 7.2.1 ,but when I try the second step in the list(that is the "make" step).it will go on a loop,and some sentences browes on my moniter and this continued for more than 1 hour til I shout down the computer what's the problem. could it be beacu

Re: [BUGS] Bug #664: Strange cursor behaviour with particular

2002-05-13 Thread Geert-Jan Van den Bogaerde
On Sun, 2002-05-12 at 17:58, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > template1=> move -1 from foo; > > MOVE 0 > > Not sure what you expected this to do, but the response should have > clued you that it didn't do anything. I suspect you are looking > for "MOVE BACKWARD 1 FROM foo" ... >

[BUGS] [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletionfollows syntax for 'DELETE']

2002-05-13 Thread Oliver Elphick
-Forwarded Message- From: der.hans <[EMAIL PROTECTED]> To: Debian Bug Tracking System <[EMAIL PROTECTED]> Subject: Bug#146689: postgresql-client: 'GRANT DELETE' autocompletion follows syntax for 'DELETE' Date: 11 May 2002 17:55:13 -0700 Package: postgresql-client Version: 7.2.1-2 Severi

Re: [BUGS] Bug #659: lower()/upper() bug on ->multibyte<- DB

2002-05-13 Thread Enke, Michael
Tatsuo Ishii wrote: > > [Cc:ed to hackers] > > (trying select convert(lower(convert('X', 'LATIN1')),'LATIN1','UNICODE');) > > > Ok, this is working now (I cann't reproduce why not at the first time). > > Good. > > > Is it planned to implement it so that I can write lower()/ upper() for multib

[BUGS] Bug #667: Lib needed when install rpm

2002-05-13 Thread pgsql-bugs
smith ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Lib needed when install rpm Long Description when i installed the rpm files of postgresql 7.2.1, it showed that it cannot find libcrypto.so.2 and libssl.so. How can I get