[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)

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

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


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

More information about the Dbix-class mailing list