Re: [BUGS] Foreign key not working in some cases when using triggers

2003-09-05 Thread Martin Edlman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Unfortunately the trigger depends on some other functions that I dind't > have so I replaced those with string constants. I couldn't get it to fail > with a little bit of playing around on my 7.3.4 box, however. The functions replacement should be

Re: [BUGS] Foreign key not working in some cases when using triggers

2003-09-04 Thread Stephan Szabo
On Fri, 5 Sep 2003, Martin Edlman wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > If possible, can you give a complete example script that shows the > > problem? > > Here it is. > Unfortunately the trigger depends on some other functions that I dind't have so I replaced those with

Re: [BUGS] Foreign key not working in some cases when using triggers

2003-09-04 Thread Martin Edlman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > If possible, can you give a complete example script that shows the > problem? Here it is. CREATE OR REPLACE FUNCTION qmail_account_check() RETURNS TRIGGER AS ' -- do some check before insert/update on qmail_account DECLARE rec1 RECORD;

Re: [BUGS] Foreign key not working in some cases when using triggers

2003-09-04 Thread Stephan Szabo
> I have problem with foreign keys on postgresql-7.3.2-1PGDG. > > I have two tables, sorry for the lenght, but I want to give you complete > information. > > Table qmail_account has FK on zone(name). On some occasions when I want > to insert data to qmail_account I get the RI error that the

[BUGS] Foreign key not working in some cases when using triggers

2003-09-04 Thread Martin Edlman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I have problem with foreign keys on postgresql-7.3.2-1PGDG. I have two tables, sorry for the lenght, but I want to give you complete information. Table qmail_account has FK on zone(name). On some occasions when I want to insert data