Removed from queue. Andrew is committing it. ---------------------------------------------------------------------------
Andrew Dunstan wrote: > > OK, now it looks like this: > > andrew=# drop table blurflx; > ERROR: table "blurflx" does not exist > andrew=# drop table if exists blurflx; > NOTICE: table "blurflx" does not exist, skipping > DROP TABLE > andrew=# create table blurflx ( x text); > CREATE TABLE > andrew=# drop table if exists blurflx; > DROP TABLE > andrew=# drop table blurflx; > ERROR: table "blurflx" does not exist > andrew=# > > revised patch attached. > > cheers > > andrew > > Tom Lane wrote: > > >Andrew Dunstan <[EMAIL PROTECTED]> writes: > > > > > >>andrew=# drop table blurflx; > >>ERROR: table "blurflx" does not exist > >>andrew=# drop table if exists blurflx; > >>DROP TABLE > >> > >> > > > >If I read MySQL's documentation correctly, they emit a NOTE (equivalent > >of a NOTICE message I suppose) when IF EXISTS does nothing because the > >table doesn't exist. Seems like we should do likewise --- your second > >example here seems actively misleading. That is, I'd rather see > > > >andrew=# drop table if exists blurflx; > >NOTICE: table "blurflx" does not exist, skipping > >DROP TABLE > > > > > > regards, tom lane > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org