| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Bryn Llewellyn <bryn(at)yugabyte(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: "create function... depends on extension..." not supported. Why? |
| Date: | 2022-04-27 13:48:40 |
| Message-ID: | 369747.1651067320@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> IIRC Abhijit and I discussed this point offline, and our conclusion was
> that DEPENDS ON EXTENSION was not of general enough usefulness to
> warrant support for it in CREATE FUNCTION -- keeping in mind that we
> would need support for it in CREATE INDEX, CREATE TRIGGER, CREATE
> MATERIALIZED VIEW as well.
Yeah. Quite aside from the code bloat and grammar bloat, my main
fear about that would be the assumption that we could wedge a consistent
syntax for this into all those different sorts of CREATE commands.
At the very least we'd probably find ourselves having to make those
keywords more reserved than they are now.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dives, Chloe | 2022-04-27 14:51:22 | Privilege error with c functions during postgresql upgrade from 11 -> 13 |
| Previous Message | Tom Lane | 2022-04-27 13:38:38 | Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac |