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

From: Laetitia Avrot <laetitia(dot)avrot(at)gmail(dot)com>
To: Chapman Flack <chap(at)anastigmatix(dot)net>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vik Fearing <vik(at)postgresfriends(dot)org>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: pg_dump new feature: exporting functions only. Bad or good idea ?
Date: 2022-03-25 16:28:45
Message-ID: CAB_COdhMAidXfeCyye9OOhech6bU6-SC4ZLw4t8CcCBkJ=5qgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Chapman,

Le ven. 25 mars 2022 à 00:42, Chapman Flack <chap(at)anastigmatix(dot)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
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-03-25 16:36:19 Re: pgsql: Add 'basebackup_to_shell' contrib module.
Previous Message Dagfinn Ilmari Mannsåker 2022-03-25 16:26:52 Re: Corruption during WAL replay