Per database connection limit buglet

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Per database connection limit buglet
Date: 2008-11-18 13:01:40
Message-ID: 937d27e10811180501k18e8aa5te98fededb8bf3892@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

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