Search Postgresql Archives

Re: Trigger/Rules Order of operations

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

 



I can't answer your question but I think you may have a serious
database design issue at hand.
Why not try to accomplish your goals in a simpler way?

Regards,
Ivan Pavlov


On Dec 15, 12:49 pm, ket...@xxxxxxxxxx (Ketema Harris) wrote:
> I am interested in finding out the pros, cons, pitfalls of using the  
> following design:
>
> Manual insert into Table A.
> Table A has a BEFORE INSERT trigger that causes an insert to table B.
> Table B has an AFTER INSERT trigger that causes an insert back to  
> table A (With different criteria not an endless loop)
>
> Table A will have its Before Trig fire again and this time the  
> criteria causes it to finish with a return new.
>
> Will the second insert into table A commit before the first insert  
> into table A?  What order does the insert into table B finish up?
>
> Ketema J. Harriswww.ketema.net
> ket...@xxxxxxxxxx
> ketemaj on iChat
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@xxxxxxxxxxxxxx)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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