Re: [BUGS] BUG #1806: Postmaster takes uses 99% of CPU

2005-08-05 Thread Richard Huxton
[EMAIL PROTECTED] wrote: The Prozess Postmaster takes 99% of Cpu. PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 20726 postgres 17 0 19996 5356 4216 R 98.3 0.3 26:36.56 postmaster 19956 postgres 19 0 19996 6148 4936 R 64.4 0.3 28:38.38 postmaster ... I have read

[BUGS] Freebsd410 and postgresql803: src/port compile error

2005-08-05 Thread rmkml
Hi, I have an error when postgresql 803 compile with flag : ./configure --prefix=/usr/local/postgres --enable-thread-safety ... gmake[4]: Leaving directory `/var/tmp/postgresql-8.0.3/src/port' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing initdb.o -L../../../src/port

Re: [BUGS] a bug in libpq, PSQL 8.0.3

2005-08-05 Thread Michael Fuhr
On Wed, Aug 03, 2005 at 01:01:53PM +0200, Adam Rad?owski wrote: > In any terminal (linux, xterm, rxvt) if I try create a new PRIMARY KEY > or any CONSTRAINT with PQexec function "I become a comment on the > screen, that the "implicit index was created", exactly this same, like > in "psql" prog

Re: [BUGS] BUG #1803: Incomplete table list in psql

2005-08-05 Thread Michael Fuhr
On Wed, Aug 03, 2005 at 10:29:38AM +0100, DKnoto wrote: > I have database with two schemas: S1 and S2. In each schema exist table T1 > but psql show only table in first schema listet in SEARCH_PATH. Is this what you mean? CREATE SCHEMA s1; CREATE TABLE s1.t1 (x integer); CREATE SCHEMA s2; CREATE