Re: Re: pg_dump new feature: exporting functions only. Bad or good idea ?

Поиск
Список
Период
Сортировка
От Laetitia Avrot
Тема Re: Re: pg_dump new feature: exporting functions only. Bad or good idea ?
Дата
Msg-id CAB_COdhMAidXfeCyye9OOhech6bU6-SC4ZLw4t8CcCBkJ=5qgw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: pg_dump new feature: exporting functions only. Bad or good idea ?  (Chapman Flack <chap@anastigmatix.net>)
Ответы Re: pg_dump new feature: exporting functions only. Bad or good idea ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello Chapman,

Le ven. 25 mars 2022 à 00:42, Chapman Flack <chap@anastigmatix.net> a écrit :
On 03/27/21 08:57, Andrew Dunstan wrote:
> We can bikeshed the name of the flag at some stage. --procedures-only
> might also make sense

Any takers for --routines-only ?

"Routine" is the genuine, ISO SQL umbrella term for a function or
procedure, and we have used it that way in our docs and glossary.

Thank you so much for your suggestion. I was really excited to find a generic term for Functions and Procedures, but "routine" also includes aggregation functions which I had excluded from my feature (see Postgres Glossary here: https://www.postgresql.org/docs/14/glossary.html#GLOSSARY-ROUTINE).

I had decided not to include aggregate functions when I designed my patch because I thought most users wouldn't expect them in the result file. Was I wrong?

Have a nice day,

Lætitia
 

Regards,
-Chap

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

Предыдущее
От: Dagfinn Ilmari Mannsåker
Дата:
Сообщение: Re: Corruption during WAL replay
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pgsql: Add 'basebackup_to_shell' contrib module.