syntax troubles using "deferrable initially deferred" - Mailing list pgsql-general

From Gauthier, Dave
Subject syntax troubles using "deferrable initially deferred"
Date
Msg-id 482E80323A35A54498B8B70FF2B8798004189C09AE@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: syntax troubles using "deferrable initially deferred"
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 8.3 - Recovering Data Directory
Next
From: David Kerr
Date:
Subject: PostgreSQL + 64 bit + performance