Problem with dumping bloom extension - Mailing list pgsql-hackers

From Thom Brown
Subject Problem with dumping bloom extension
Date
Msg-id CAA-aLv7WHGnidt=JwSKMZHPRpOEK9x59HQAW7vMfeyvqAJvu4g@mail.gmail.com
Whole thread Raw
Responses Re: Problem with dumping bloom extension  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Dmitry Igrishin
Date:
Subject: Re: PATCH: Batch/pipelining support for libpq
Next
From: Robert Haas
Date:
Subject: Re: Rename max_parallel_degree?