-----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----- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
