Re: drop if exists remainder

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: drop if exists remainder
Дата
Msg-id 43E8046A.7030108@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: drop if exists remainder  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: drop if exists remainder  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
>>> 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 :)

Chris


В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [INTERFACES] [BUGS] BUG #2171: Differences compiling plpgsql in
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: drop if exists remainder