syntax troubles using "deferrable initially deferred"

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: syntax troubles using "deferrable initially deferred"
Date: 2009-09-14 18:10:41
Message-ID: 482E80323A35A54498B8B70FF2B8798004189C09AE@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

create table templates
(
template text,
constraint template_not_null_check (template is nit null) deferrable initially deferred);

ERROR syntax error at or near "DEFERRABLE"
LINE 4: ...nt template_not_null_check (template is not null) DEFERRABLE...

Without the "deferrable initially deferred" it creates OK.

v8.3.4. on linux

Thanks in Advance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lawson Bradley 2009-09-14 19:10:57 PG 8.3 - Recovering Data Directory
Previous Message Scott Marlowe 2009-09-14 17:57:11 Re: Locks in postgres causing system load and crash.