DROP FOREIGN KEY is not valid in PostgreSQL

DROP FOREIGN KEY is not valid in PostgreSQL

Submitted by dbs on Sat, 09/10/2011 - 23:53
Issue ID:3314
Issue Category:bug
Component:core
Priority:normal
Status:active
Assigned:Unassigned
Version:1.0

When upgrading from 0.8.3 to 1.0.x on PostgreSQL 9.0, I ran into errors because checkschema.php was trying to drop foreign keys with DROP FOREIGN KEY clauses instead of DROP CONSTRAINT.

I pushed a fix for this in https://gitorious.org/~dbs/statusnet/dbs-mainline/commit/8f5b3d2ceaa9c00...

Updates

Login or Register to modify this issue, or to receive updates by email.

You can also subscribe to the RSS feed for updates to this issue.