On Wed, 9 Jun 2004, Mauri Sahlberg wrote:
> rahaks=# begin foo
> rahaks-# ;
> ERROR: parser: parse error at or near "foo" at character 7
> rahaks=# begin;
> BEGIN
> rahaks=# set constraints all deferred;
> SET CONSTRAINTS
In addition to the other messages, the above only defers deferrable
constraints. If you didn't specify initially deferred or deferrable when
creating the fk constraint, the above will not affect it.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
