Thanks a lot for the help Remy, I dropped the view and the error gone, run with other issues but all is fixed after all. I guess I will restore the view when I migrate all the environments.
On Fri, Mar 18, 2011 at 9:21 PM, Sherif Shehab Aldin <[email protected]>wrote: > Greetings Remy, > > Thanks a lot for help, I will have to wait till Sunday to try it tho cause > of the weekend, I will message you back with the result. :) > > > On Fri, Mar 18, 2011 at 7:25 PM, Remy Blank <[email protected]> wrote: > >> silentnights wrote: >> > And now when I run trac-admin $env upgrade --no-backup I get this >> > error: >> > >> > NotSupportedError: cannot alter type of a column used by a view or >> > rule >> > DETAIL: rule _RETURN on view trac_view.ticket depends on column >> > "changetime" >> >> It looks like someone has created a view named "trac_view.ticket" that >> references the column "changetime" in the "ticket" table. This field is >> altered during the upgrade procedure to 0.12, and this doesn't seem to >> be possible on PostgreSQL while the view exists. >> >> You should delete all views that reference Trac tables, run the Trac >> upgrade procedure, then re-create the views. >> >> -- Remy >> >> > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
