That jogged a neuron... Yes your right, that was the first case we encountered in our trigger problem and I assume that it will only apply to that field/table on postgres 7.3.
I would advise that in the future if you decide to go on to > 7.3 that you take the strategy I've outlined in the wiki to cleanup your db schema etc. But you should be ok for now if you continue on 7.3 without those triggers. -Mark On Sep 12, 2008, at 12:16 PM, Bill Jordan wrote: > > On Thu, 11 Sep 2008 at 11:38, Mark Diggory wrote: > >> My only concern is that the Triggers may actually necessary in 7.3. >> You should thoroughly investigate that. > > After some testing, I'm convinced these triggers are only there to > keep the mets_bitstream_id in sync with the bitstream table. > Without the mets_bitstream_id, there is nothing for these triggers > to do. And in fact if I modify the pre-1.5 database_schema.sql by > removing the mets_bitstream_id column, the triggers are never created. > > --Bill > > **************************************************************** > William Jordan > Associate Dean > University of Washington Libraries > Resource Acquisition and Description/ > Information Technology Services Box 352900, Seattle, WA 98195-2900 > Voice: (206) 685-1625 Fax: (206) 543-5457 > **************************************************************** ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
