Thanks will check it out Akshay On 21 Nov 2013 18:44, "Thomas Mueller" <[email protected]> wrote:
> Hi, > > This should be fixed now (in the trunk). > > Regards, > Thomas > > > > On Sat, Nov 16, 2013 at 2:37 PM, Thomas Mueller < > [email protected]> wrote: > >> Hi, >> >> Thanks for reporting! This is a bug. The database is supposed to drop the >> objects in the right order; it looks like it doesn't do that currently in >> this case. I will try to fix it. Test case: >> >> create table a(x int); >> create view b as select * from a; >> create table c(y int check (select count(*) from b) = 0); >> drop all objects delete files; >> >> Regards, >> Thomas >> >> >> >> On Fri, Nov 15, 2013 at 4:11 PM, Akshay Mehta <[email protected]>wrote: >> >>> Hi, >>> >>> Is the Statement "Drop All Objects" still checking for dependencies? >>> >>> I have a constraint on a Table A, which Checks the value of a column in >>> a Particular View B. However using "Drop All Objects" reports an error : >>> "Table A depends on B". >>> >>> Any Ideas? >>> >>> regards >>> Akshay >>> >>> I am Using: H2 1.3.174 >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
