add constraint deferrable, syntax error

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: add constraint deferrable, syntax error
Date: 2012-01-11 16:05:57
Message-ID: 0AD01C53605506449BA127FB8B99E5E101BEE3@FMSMSX106.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Why am I getting this?

xdb=# alter table templates add constraint manager_uid_is_invalid check ((constraint_checker('manager',manager,null,null)) = 'OK') DEFERRABLE ;
ERROR: syntax error at or near "DEFERRABLE"
LINE 1: ...int_checker('manager',manager,null,null)) = 'OK') DEFERRABLE...

v8.3.4 on linux

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-01-11 16:49:03 Re: question about the money type
Previous Message vyang 2012-01-11 16:03:21 Keywords