Hi, It was my mistake that I forgot to mention the View was in a different schema. Will this make a difference ?
regards Akshay On Thu, Nov 21, 2013 at 7:14 PM, Akshay Mehta <[email protected]>wrote: > 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. >> > -- Akshay Mehta Ph. - 09302104522 -- 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.
