Thank you very much. With DEFERRABLE INITIALLY DEFERRED (at the end of
the constraint) it works fine now
Sebastian Böck schrieb:
Oleg wrote:
Dear All,
is it possible to temporary deactivate a constraint in PostgreSQL?
There is a constraint that does not allow me to write some data (see
e-mail below). But after all datasets are written the constraint is
valid. So I was wondering wether it is possible to deactivate a
constraint write all records in all tables then activate constraint
again. Somebody told me that it is possible in Oracle.
Thanks a lot in advance
Oleg
Have you tried to make the Foreign Key deferrable and initially deferred?
See:
http://www.postgresql.org/docs/8.0/interactive/sql-createtable.html
HTH
Sebastian
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
