[GENERAL] drop table if exists VIEW_NAME;

2012-09-19 Thread Marc Mamin
hello, I've found a small logical issue while writing a migration script: create table vtest (foo int); create view vtest_v as select * from vtest; drop table if exists vtest_v; ERROR: vtest_v is not a table drop view if exists vtest; ERROR: vtest is not a view this may be seen as a nice

Re: [GENERAL] drop table if exists VIEW_NAME;

2012-09-19 Thread Craig Ringer
On 09/19/2012 07:54 PM, Marc Mamin wrote: hello, I've found a small logical issue while writing a migration script: create table vtest (foo int); create view vtest_v as select * from vtest; drop table if exists vtest_v; ERROR: vtest_v is not a table drop view if exists vtest; ERROR: