[odb-users] Error: Relation "schema_version" already exists

[Boris Kolpackov]

Hi Arnaud,

Arnaud Kapp <arnaud.kapp at islog.com> writes:

> The problem is, when targeting Postgre, an exception is thrown
> when creating the second schema. The first one gets created ok,
> then `42P07: ERROR:  relation "schema_version" already exists` is
> thrown.

PostgreSQL prior to 9.1 doesn't have support for IF NOT EXISTS clause
in CREATE TABLE. As a result, if targeting any PG version ODB can't
do much about it. You can tell ODB you are using 9.1 or later with:

--pgsql-server-version 9.1

Boris