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

Boris Kolpackov boris at codesynthesis.com
Mon Sep 12 11:06:05 EDT 2016


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



More information about the odb-users mailing list