Problem defining deferred check constraints

[Thomas Kellerer <spam_eater@xxxxxxx>]

Hi,

I'm playing around with deferred constraints and according to the manual, it 
should be possible to declare a check constraint as deferred.

At least that's how I read the definition of /column_constraint/ at 
http://www.postgresql.org/docs/8.3/static/sql-createtable.html

What I tried:

CREATE TABLE my_check_test
(
  some_value integer
      constraint value_check
         check (some_value > 0) DEFERRABLE INITIALLY DEFERRED
);

That gives me the following error:

ERROR:  misplaced DEFERRABLE clause

(when I remove "DEFERRABLE INITIALLY DEFERRED", it works)

OK, so I tried to define the constraint at the end of the table definition:

CREATE TABLE my_check_test
(
  some_value integer,

  CONSTRAINT value_check
         CHECK (some_value > 0) DEFERRABLE INITIALLY DEFERRED
);

(Note the comma after the column definition)

That gives me: ERROR: syntax error at or near "DEFERRABLE"

OK, say maybe it's not possible with an "inline" constraint, so I tried to add 
the constraint after creating the table:

ALTER TABLE my_check_test
  ADD CONSTRAINT value_check
    CHECK (some_value > 0) DEFERRABLE INITIALLY DEFERRED
;

gives me: ERROR: syntax error at or near "DEFERRABLE"

The above (ADD CONSTRAINT) syntax works when using it for a foreign key (so the 
keywords for deferring the constraint are at the right place)


I'm sure I'm missing something very obvious, but what? :)

Thanks for any input
Thomas




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general