Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Tom LaneDate: 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 HerreraDate: 2008-11-18 11:50:50
Subject: Re: Re: [BUGS] libpq does not manage SSL callbacksproperly when other libraries are involved.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group