Tripal_analysis_blast updb problem with Postgres 8.4

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Tripal_analysis_blast updb problem with Postgres 8.4

Michael Dondrup-3
Hi,

I am now enabling the Tripal extension modules again, I've got another little glitch.
running updatedb, I get an SQL error from update 7201
for DROP CONSTRAINT IF EXISTS
We are running postgres 8.4, so I checked the documentation, IF EXISTS was not defined for DROP CONSTRAINT before postgres 9.

I think I can fix that myself in update 7201, just in case someone stumbles on that as well.

Michael


drush updatedb
 Tripal_analysis_blast  7201  Adds missing foreign key constraints                      
 Tripal_analysis_blast  7202  Adds the blast property terms to the correct vocabulary.
Do you wish to run all pending updates? (y/n): y
Failed to update foriegn key: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near     [error]
"EXISTS"
LINE 3:       DROP CONSTRAINT IF EXISTS blast_hit_data_db_id_fkey CA...
                                 ^
Performed update: tripal_analysis_blast_update_7201                                                [ok]
'all' cache was cleared.                                                                           [success]
Finished performing updates.                    




------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal