Re: BUG #12808: BDR lock adding Postgis extension in one node

Hi,

On 2015-02-26 16:29:25 +0000, rmelendo@teltronic.es wrote:
> Using BDR with 2 nodes and trying to add a PostGIS extension in node 1,=
 it
> adds the extension and automatically adds =E2=80=9Cspatial_ref_sys=E2=80=
=9D.
>=20
> In node2, it tries to add the extension and gets an error because table
> =E2=80=9Cspatial_ref_sys=E2=80=9D does not exists. The bbdd gets locked=
 after that.

(this isn't the best forum for this, but I don't really know what to
recommend besides -general)

What's the exact error message? Does it out because of the extension or
because of inserts into that table?

Which version of bdr does this happen with? Because I seem to recall
fixing a similar problem... If not, we'll look into the issue.

Greetings,

Andres Freund

--=20
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services