Re: drop if exists remainder

Christopher Kings-Lynne wrote:
> >>> Here's a first draft patch for DROP ... IF EXISTS for the remaining
> >>> cases, namely: LANGUAGE, TABLESPACE, TRIGGER OPERATOR CLASS,
> >>> FUNCTION, AGGREGATE, OPERATOR, CAST and RULE.
> >>>
> >>
> >> At what point does this stop being useful and become mere bloat?
> >> The only case I can ever recall being actually asked for was the
> >> TABLE case ...
> >
> > Chris KL said it should be done for all on the grounds of consistency.
> > But I will happily stop right now if that's not the general view - I'm
> > only doing this to complete something I started.
>
> Well, my use-case was to be able to wrap "pg_dump -c" output in
> begin/commit tags and being able to run and re-run such dumps without
> errors.  Basically I don't like 'acceptable errors' when restoring dumps
> :)  They just confuse newer users especially.
>
> I also just like consistency :)

Makes sense.

--
  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