[GENERAL] function depend on view

2012-08-20 Thread salah jubeh
Hello Guys, I am having a scenario close to the one below, I have defined a function which depends on a view. I am able to drop the view, but my server did not complain about the dependency. In the scenario  below, one can drop the views a2 and a1 respectively, and when executing a3(),

Re: [GENERAL] function depend on view

2012-08-20 Thread Andreas Kretschmer
salah jubeh s_ju...@yahoo.com wrote: Hello Guys, I am having a scenario close to the one below, I have defined a function which depends on a view. I am able to drop the view, but my server did not complain about the dependency. In the scenario below, one can drop the views a2 and a1

Re: [GENERAL] function depend on view

2012-08-20 Thread salah jubeh
: Monday, August 20, 2012 2:47 PM Subject: Re: [GENERAL] function depend on view salah jubeh s_ju...@yahoo.com wrote: Hello Guys, I am having a scenario close to the one below, I have defined a function which depends on a view. I am able to drop the view, but my server did not complain about

Re: [GENERAL] function depend on view

2012-08-20 Thread Merlin Moncure
On Mon, Aug 20, 2012 at 9:37 AM, salah jubeh s_ju...@yahoo.com wrote: Hello Andreas, Thanks for the reply, The example I have posted is very simple and you are right it is very similar to select max (id) from table_that_does_not_exist; But there are more here, for example imagine I have

Re: [GENERAL] function depend on view

2012-08-20 Thread Andreas Kretschmer
salah jubeh s_ju...@yahoo.com wrote: Hello Andreas, Thanks for the reply, The example I have posted is very simple and you are right it is very similar to select max (id) from table_that_does_not_exist; But there are more here, for example imagine I have something like CREATE VIEW a4

Re: [GENERAL] function depend on view

2012-08-20 Thread Merlin Moncure
On Mon, Aug 20, 2012 at 9:59 AM, Andreas Kretschmer akretsch...@spamfence.net wrote: salah jubeh s_ju...@yahoo.com wrote: Hello Andreas, Thanks for the reply, The example I have posted is very simple and you are right it is very similar to select max (id) from table_that_does_not_exist;