Re: BUG #1740: Deferred foreign key constraint isn't deferred

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Big, big mistake... Thanks for the help, sorry about the post...

Michael Fuhr wrote:
> On Thu, Jun 30, 2005 at 02:01:39PM +0100, Daniel Cristian Cruz wrote:
>
>>ALTER TABLE ONLY mat_comissao_itens
>> ADD CONSTRAINT mat_nf_saida_itens_pa_mat_comissao_itens FOREIGN KEY
>>(mat_nfs_diretorio, mat_nfs_in_codigo, mat_nsi_in_ordem) REFERENCES
>>mat_nf_saida_itens(mat_nfs_diretorio, mat_nfs_in_codigo, mat_nsi_in_ordem)
>>ON UPDATE RESTRICT ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED;
>
>
> Note the following in the CREATE TABLE documentation:
>
> RESTRICT
>
> Produce an error indicating that the deletion or update would
> create a foreign key constraint violation. This is the same as
> NO ACTION except that the check is not deferrable.
>
> http://www.postgresql.org/docs/8.0/static/sql-createtable.html
>

- --
Daniel Cristian Cruz

Desenvolvimento Mega Small Business
Ramal 8511
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCw/kU6TuR6lz8YgMRArTSAJ9QH8u6IRhBDu5/4CfsgIu6/M9dTwCfWApU
+9ejxg51x5QnZAXcFcI0odM=
=4zgh
-----END PGP SIGNATURE-----