| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source |
| Date: | 2022-12-02 02:41:30 |
| Message-ID: | 1852623.1669948890@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I wrote:
> We could partially fix that by teaching psql to also recognize
> "BEGIN" as the start of the function body.
Looks like we need "RETURN " too, so more or less as attached.
(I didn't bother with a test case yet. \sf wouldn't be too
hard to exercise, but I wonder how we could test \ef portably.)
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| fix-psql-sf-ef-for-new-style-functions.patch | text/x-diff | 4.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2022-12-02 09:20:44 | Re: Incorrect messages emitted from pgoutput when using column lists |
| Previous Message | Richard Guo | 2022-12-02 02:30:31 | Re: hashing bpchar for nondeterministic collations is broken |