Re: [BUGS] psql's \h listing of commands doesn't look nice anymore

2008-01-20 Thread Tom Lane
I wrote: > Not sure if we want to consider dropping down to two columns, but in any > case I'd say a minimum requirement is at least two spaces between one > command and the one beside it (not one space, since we have multi-word > commands). Actually, it seems to look all right with only one space

Re: Gentoo shared_buffers setting (was: [BUGS] BUG #3888: postmaster...)

2008-01-20 Thread Tom Lane
Marti <[EMAIL PROTECTED]> writes: > On 1/20/08, Tom Lane <[EMAIL PROTECTED]> wrote: >> It's sort of irrelevant IMHO, as any useful setting is orders of >> magnitude larger than that anyway. > Gentoo defaults to launching PostgreSQL 8.2 with "-N 40 -B 80" which > is how I hit this problem; this was

[BUGS] psql's \h listing of commands doesn't look nice anymore

2008-01-20 Thread Tom Lane
8.3's admittedly-pretty-verbose new commands for text search configuration do not play nice with psql's \h listing of "available help". I see stuff like ALTER LANGUAGECREATE TABLE EXECUTE ALTER OPERATOR CLASS CREATE TABLE AS EXPLAIN ALTER OPER

Re: [BUGS] BUG #3888: postmaster: misleading error message for illegal -B values

2008-01-20 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Marti Raudsepp wrote: >> However, as of PostgreSQL 8.3, postmaster requires that the number of >> buffers is at least (max_connections*2 + 6) > Hmm. The minimum is actually (max_connections + max_autovacuum_workers) > * 2. The default max_autovac

Re: [BUGS] BUG #3887: pgAdmin hang when click on database

2008-01-20 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Jan 19, 2008 at 08:27:42AM +, John Cota wrote: > > The following bug has been logged online: > > Bug reference: 3887 [...] > Postgresql 8.2 on Fedora Core 8/VMware Server 1.04 > pgAdmin III on xp sp2 > > I'm able to access it via

Re: [BUGS] BUG #3888: postmaster: misleading error message for illegal -B values

2008-01-20 Thread Heikki Linnakangas
Marti Raudsepp wrote: Bug reference: 3888 Logged by: Marti Raudsepp Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC1 Operating system: Linux AMD64 Description:postmaster: misleading error message for illegal -B values Details: When launching postmaster w

[BUGS] BUG #3888: postmaster: misleading error message for illegal -B values

2008-01-20 Thread Marti Raudsepp
The following bug has been logged online: Bug reference: 3888 Logged by: Marti Raudsepp Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC1 Operating system: Linux AMD64 Description:postmaster: misleading error message for illegal -B values Details: When lau

[BUGS] BUG #3887: pgAdmin hang when click on database

2008-01-20 Thread John Cota
The following bug has been logged online: Bug reference: 3887 Logged by: John Cota Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: fedora core 8 Description:pgAdmin hang when click on database Details: Postgresql 8.2 on Fedora Core 8/VMwar

[BUGS] pgsql problem

2008-01-20 Thread Tanasiciuc Ilie-Ovidiu
Hi. I want to make a trigger for more tables that then i try to make a update to make a new insert. i find a solution in next syntax INSERT INTO TG_RELNAME SELECT NEW.*; RETURN OLD; the problem is that the primary key is violated because NEW.id_client already exists. i try to find a solution for