|
»
»
»
dropAll doesn't remove functions under mysql
|
View:
New views
6 Messages
—
Rating Filter:
Alert me
|
 |
dropAll doesn't remove functions under mysql
by Jensomato
::
Rate this Message:
Hi all,
I'm using liquibase 1.7 with mysql 5.0.51. Using the dropAll command drops all database objetcs except for functions. Is this the intended behavior? Regards Jens |
|
|
Re: dropAll doesn't remove functions under mysql
by Voxland, Nathan
::
Rate this Message:
It is the intended behavior currently. I'm hoping to get support for
listing and dropping procedures in a future release, but have not had the time to work on it yet. For now, you will have to drop the functions manually Nathan -----Original Message----- From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of Jensomato Sent: Friday, July 11, 2008 7:33 AM To: liquibase-user@... Subject: [Liquibase-user] dropAll doesn't remove functions under mysql Hi all, I'm using liquibase 1.7 with mysql 5.0.51. Using the dropAll command drops all database objetcs except for functions. Is this the intended behavior? Regards Jens -- View this message in context: http://www.nabble.com/dropAll-doesn%27t-remove-functions-under-mysql-tp1 8402818p18402818.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------ - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: dropAll doesn't remove functions under mysql
by nodje
::
Rate this Message:
A related issue that may be worth mentioning:
DropAll seems to have problem dropping tables in some cases due -most probably- to foreignkeys (I experienced it with the Quartz scheduler tables on MySQL). AFAIK, this is consistent with the database GUI which gives the same problem when trying to select all-> drop. I don't know of any dropall tool (on mysql as well as SQLServer at least) that could order the table drops either. -nodje
|
|
|
Re: dropAll doesn't remove functions under mysql
by Voxland, Nathan
::
Rate this Message:
I have ran into this a few times but haven't gotten it fully troubleshot
yet. The dropAll functionality should drop all the foreign keys first and then drop all the tables. I'll add the issue to the tracker so it gets addressed. I've generally been able to run dropAll a second time and it drops the remaining tables, you may want to try that. Nathan -----Original Message----- From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of nodje Sent: Thursday, July 17, 2008 9:58 PM To: liquibase-user@... Subject: Re: [Liquibase-user] dropAll doesn't remove functions under mysql A related issue that may be worth mentioning: DropAll seems to have problem dropping tables in some cases due -most probably- to foreignkeys (I experienced it with the Quartz scheduler tables on MySQL). AFAIK, this is consistent with the database GUI which gives the same problem when trying to select all-> drop. I don't know of any dropall tool (on mysql as well as SQLServer at least) that could order the table drops either. -nodje Voxland, Nathan wrote: > > It is the intended behavior currently. I'm hoping to get support for > listing and dropping procedures in a future release, but have not had > the time to work on it yet. For now, you will have to drop the > functions manually > > Nathan > > -----Original Message----- > From: liquibase-user-bounces@... > [mailto:liquibase-user-bounces@...] On Behalf Of > Jensomato > Sent: Friday, July 11, 2008 7:33 AM > To: liquibase-user@... > Subject: [Liquibase-user] dropAll doesn't remove functions under mysql > > > Hi all, > > I'm using liquibase 1.7 with mysql 5.0.51. > Using the dropAll command drops all database objetcs except for > functions. > Is this the intended behavior? > > Regards Jens > -- > View this message in context: > > 8402818p18402818.html > Sent from the LiquiBase - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------ > - > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > - > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > -- View this message in context: http://www.nabble.com/dropAll-doesn%27t-remove-functions-under-mysql-tp1 8402818p18521753.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------ - 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=/ _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- 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=/ _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
|
|
Re: dropAll doesn't remove functions under mysql
by nodje
::
Rate this Message:
To be precise, I remember now that I was using the dropFirst parameter option through a Maven configuration. I assume this would trigger a DropAll but I'm not certain.
Anyway, the Quartz set of table should constitute a good test case. -nodje
|
|
|
Re: dropAll doesn't remove functions under mysql
by Voxland, Nathan
::
Rate this Message:
The dropFirst attribute does cause a dropAll to be performed. I'll use
the quartz table set and do some more testing and hopefully get a fix in for the 1.8 release. Nathan -----Original Message----- From: liquibase-user-bounces@... [mailto:liquibase-user-bounces@...] On Behalf Of nodje Sent: Friday, July 18, 2008 9:47 PM To: liquibase-user@... Subject: Re: [Liquibase-user] dropAll doesn't remove functions under mysql To be precise, I remember now that I was using the dropFirst parameter option through a Maven configuration. I assume this would trigger a DropAll but I'm not certain. Anyway, the Quartz set of table should constitute a good test case. -nodje Voxland, Nathan wrote: > > I have ran into this a few times but haven't gotten it fully troubleshot > yet. The dropAll functionality should drop all the foreign keys first > and then drop all the tables. I'll add the issue to the tracker so it > gets addressed. I've generally been able to run dropAll a second time > and it drops the remaining tables, you may want to try that. > > Nathan > > -----Original Message----- > From: liquibase-user-bounces@... > [mailto:liquibase-user-bounces@...] On Behalf Of > Sent: Thursday, July 17, 2008 9:58 PM > To: liquibase-user@... > Subject: Re: [Liquibase-user] dropAll doesn't remove functions under > mysql > > > A related issue that may be worth mentioning: > DropAll seems to have problem dropping tables in some cases due -most > probably- to foreignkeys (I experienced it with the Quartz scheduler > tables > on MySQL). > AFAIK, this is consistent with the database GUI which gives the same > problem > when trying to select all-> drop. > I don't know of any dropall tool (on mysql as well as SQLServer at > least) > that could order the table drops either. > > -nodje > > > Voxland, Nathan wrote: >> >> It is the intended behavior currently. I'm hoping to get support for >> listing and dropping procedures in a future release, but have not had >> the time to work on it yet. For now, you will have to drop the >> functions manually >> >> Nathan >> >> -----Original Message----- >> From: liquibase-user-bounces@... >> [mailto:liquibase-user-bounces@...] On Behalf Of >> Jensomato >> Sent: Friday, July 11, 2008 7:33 AM >> To: liquibase-user@... >> Subject: [Liquibase-user] dropAll doesn't remove functions under >> >> >> Hi all, >> >> I'm using liquibase 1.7 with mysql 5.0.51. >> Using the dropAll command drops all database objetcs except for >> functions. >> Is this the intended behavior? >> >> Regards Jens >> -- >> View this message in context: >> > >> 8402818p18402818.html >> Sent from the LiquiBase - User mailing list archive at Nabble.com. >> >> >> > ------------------------------------------------------------------------ >> - >> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! >> Studies have shown that voting for your favorite open source project, >> along with a healthy diet, reduces your potential for chronic lameness >> and boredom. Vote Now at http://www.sourceforge.net/community/cca08 >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@... >> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> >> > ------------------------------------------------------------------------ > - >> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! >> Studies have shown that voting for your favorite open source project, >> along with a healthy diet, reduces your potential for chronic lameness >> and boredom. Vote Now at http://www.sourceforge.net/community/cca08 >> _______________________________________________ >> Liquibase-user mailing list >> Liquibase-user@... >> https://lists.sourceforge.net/lists/listinfo/liquibase-user >> >> > > -- > View this message in context: > > 8402818p18521753.html > Sent from the LiquiBase - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------ > - > 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=/ > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > - > 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=/ > _______________________________________________ > Liquibase-user mailing list > Liquibase-user@... > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > -- View this message in context: http://www.nabble.com/dropAll-doesn%27t-remove-functions-under-mysql-tp1 8402818p18540747.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------ - 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=/ _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------- 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=/ _______________________________________________ Liquibase-user mailing list Liquibase-user@... https://lists.sourceforge.net/lists/listinfo/liquibase-user |
| Free Forum Powered by Nabble | Forum Help |