[Dbix-class] infinite loop when calling accessors on a table with triggers

John Napiorkowski jjn1056 at yahoo.com
Wed May 3 16:59:32 CEST 2006


I'm having a strange problem with a table that has
some triggers on it.  The issue is that when I try to
fetch from the table via an accessor created by a
'has_many' relationship the system goes into an
infinite loop.

Here are the details.

Table Documents
 document_id (primary_key)
 (etc)

Table Folders
 folder_id (primary_key)
 document_id (primary_key)
 parent_id (FK to folder_id, a self referential FK)
 (etc)

I have a trigger on table Folders to check during
update or inserts to see if parent_id IS NULL, and if
so to set it to the value of folder_id.

I don't seem much in the documentation regarding
triggers.  I also have a local archive of the mailing
list and could find anyone with similar trouble.  So
my question is: Is this a known problem?  Have other
people run into it?  Or have other people gotten
triggers with dbix working without trouble.

Please let me know if I can provide more info to help
with this problem.

By the way way database is postgresql 8.1

--john

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the Dbix-class mailing list