Onde está
*CONSTRAINT* noticia_materia_ck *CHECK*(materia <> ''),

coloque

*CONSTRAINT* noticia_materia_ck *CHECK*(length(materia) > 0),

Deve resolver.

BEGIN; *ALTER TABLE* noticia *DROP CONSTRAINT* noticia_materia_ck, *ADD* *
CONSTRAINT* noticia_materia_ck *CHECK*(length(materia) > 0);* COMMIT;*

2008/9/12 Leonel Freire <[EMAIL PROTECTED]>

> Sim, eu mesmo criei. Qual o relacionamento dessa constraint com um index?
>
> Leonel Freire
>
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
>


-- 
William Leite Araújo
Analista de Banco de Dados - QualiConsult
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a