Hi,
If a database with the bloom extension installed is dumped and restored,
there's an error with the access method creation:
createdb bloomtest
psql -c 'CREATE EXTENSION bloom;' bloomtest
pg_dump -d bloomtest > ~/tmp/bloom.sql
createdb bloomtest2
psql -d bloomtest2 -f ~/tmp/bloom.sql
The output of the last command produces:
"psql:/home/thom/tmp/bloom.sql:48: ERROR: access method "bloom" already
exists"
So pg_dump shouldn't be dumping this access method as it's part of the
extension.
Regards
Thom