Search Postgresql Archives

syntax troubles using "deferrable initially deferred"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux