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: "vtest" is not a view
this may be seen as a nice hint, but in my own opinion
DROP ... IF EXISTS should not throw an error for objects that do not exist.
... but they do exist. There is another object with that name. It isn't
clear if the script author's intention is to DROP the object despite the
type mismatch, or to ignore it because it's not the type of object they
specified to drop.
When something is ambiguous or unclear, PostgreSQL will tend to report
an error for safety.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general