pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'

Hi,

I noticed that when using the single commandline:

drop database <name>; create database <name>;

this sometimes fails due to a pg_autovacuum process running on the background.


When this happens, the error returned is:

db2=# drop database db1; create database db1;
DROP DATABASE
ERROR:  source database "template1" is being accessed by other users



The logs shows that pg_autovacuum kicks in right after the drop database, but
right before the create database, causing the latter to fail:


2003-11-08 10:50:15 [1422] LOG:  unexpected EOF on client connection
2003-11-08 10:50:46 [1424] LOG:  connection received: host=<ip> port=<port>
2003-11-08 10:50:46 [1424] LOG:  connection authorized: user=<my_name>
database=db2
2003-11-08 10:50:52 [1424] LOG:  query: drop database db1;
2003-11-08 10:50:55 [1426] LOG:  connection received: host=[local] port=
2003-11-08 10:50:55 [1426] LOG:  connection authorized:
user=<pg_autovacuum_user> database=template1
2003-11-08 10:50:56 [1424] LOG:  query:  create database db1;
2003-11-08 10:50:56 [1424] ERROR:  source database "template1" is being
accessed by other users


Obviously, simply reentering 'create database db1' corrects the problem ;-)


db2=# select version();
                             version
------------------------------------------------------------------
 PostgreSQL 7.4beta3 on i586-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)


pg_autovacuum is started using the options '-D -d2'




This may very well be expected behaviour, but I didn't find anything on it in
pg_autovacuum's README or TODO, so just in case it is a bug.......




--
Best,




Frank van Vugt