It's possible to set a per-database connection limit of < -1, which seems bogus:

gator:~ dpage$ /usr/local/pgsql84/bin/psql -p 5433 postgres
psql (8.4devel)
Type "help" for help.

postgres=# create database test with connection limit = -999;
CREATE DATABASE
postgres=# select datname, datconnlimit from pg_database;
  datname  | datconnlimit
-----------+--------------
 template1 |           -1
 template0 |           -1
 postgres  |           50
 foo       |           45
 test      |         -999
(5 rows)

8.3 seems similarly afflicted - I haven't tested any further back.

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Responses

• Re: Per database connection limit buglet at 2009-01-26 12:26:05 from Heikki Linnakangas

pgsql-bugs by date

Next:	From: Tom Lane	Date: 2008-11-18 16:20:50
	Subject: Re: Re: [BUGS] libpq does not manage SSL callbacks properly when other libraries are involved.
Previous:	From: Alvaro Herrera	Date: 2008-11-18 11:50:50
	Subject: Re: Re: [BUGS] libpq does not manage SSL callbacksproperly when other libraries are involved.