Re: [BUGS] Bug #934: readline.h not found during configure

2003-04-04 Thread Stephan Szabo
On Fri, 4 Apr 2003 [EMAIL PROTECTED] wrote: > Bill Eichin ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > readline.h not found during configure > > Long Description > I'm running debian woody, and I've been revisiting t

[BUGS] Bug #934: readline.h not found during configure

2003-04-04 Thread pgsql-bugs
Bill Eichin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description readline.h not found during configure Long Description I'm running debian woody, and I've been revisiting this problem for several months. I had no choice during comp

Re: [BUGS] Psql 'Expanded display (\x)' behaviour

2003-04-04 Thread Peter Eisentraut
Ennio-Sr writes: > toggling on/off the 'Expanded display' (in psql) does affect the display > of non-ascii chars. Not at all. It's only an alternative table format. > but tried other charsets with the same result: accented letters display > ok only when 'expanded display' is turned off (in whic

[BUGS] Psql 'Expanded display (\x)' behaviour

2003-04-04 Thread Ennio-Sr
Hello! I'm new to this list and hope it is the right one (I posted to General and Novice but got no answer). I know that issues concerning the (erroneously) so called extended ASCII chars are of partial interest to English speaking people ... so I should be very grateful if any of you could confir

Re: [BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2

2003-04-04 Thread Tom Lane
"Robert John Shepherd" <[EMAIL PROTECTED]> writes: > Help! (And sorry if this is the wrong list) Yes, it's the wrong list. pgsql-performance would be the place to discuss this. We can't help you anyway without more details: show us the EXPLAIN ANALYZE results for some of the slow queries. (Idea

[BUGS] index problem when renaming a table

2003-04-04 Thread lists
Hi , I used the command: ALTER TABLE TEST_TABLE RENAME TO TEST_TABLE_01; and tried to create a new one, based on the old, with some more fields. But when I create the primary key, it says that it's name is already used and it can't be dome, and exits. Then I have to drop the old table's inde

[BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2

2003-04-04 Thread Robert John Shepherd
Up until a few days ago I have been running Postgresl 7.2.3 with Tsearch from the contrib dir, but at various times the performance of the database would suddenly and rapidly deteriate so that queries which previously took 500ms then took 8 or 9 seconds. The only cure is a backup and restore of th