Database side code (such as Triggers and Functions) tend to break the benefits of developing software using an ORM like Propel or Doctrine as one of the biggest advantages of using ORM's is to be database agnostic. By having database side Triggers and Functions you are tying yourself to the database and therefore gain little to no benefit using an ORM.
We recently removed all database-side coding on our mysql server for this very reason. It is far easier and simpler to manage ONE resource that contains all code (such as your symfony PHP application) than having to try and maintain a bunch of disparate systems all with their own pieces of code etc. And to answer your question ... no you can't use the schema.yml to create triggers with. My advice is ... don't use them. On Tue, Dec 14, 2010 at 6:21 PM, Andre Lopes <lopes80an...@gmail.com> wrote: > Hi, > > I'm coding the Jobeet example from the Symfony website but I'm with some > doubts about a subject... > > For my projects I use PostgreSQL Database, and in all my projects I end up > with a Database with a lot of Triggers and Functions. How can I deal with > this subject with the "schema.yml" and the "symfony doctrine:build --all > --and-load --no-confirmation". > > There is a way of defining the schema in SQL or can be done in other way? > > Ps: Sorry for my bad english. > > > Best Regards, > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to symfony-users@googlegroups.com > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
