| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Bryn Llewellyn <bryn(at)yugabyte(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Wrong results from function that selects from vier after "created or replace" |
| Date: | 2020-10-13 00:38:38 |
| Message-ID: | CAKFQuwYmMpnE_ay+OP9Z2x-2+WhM9y53N6JfbFRyZDOZiViWsg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Oct 12, 2020 at 5:01 PM Bryn Llewellyn <bryn(at)yugabyte(dot)com> wrote:
> *WRONG RESULTS FROM FUNCTION THAT SELECTS FROM VIER AFTER "CREATED OR
> REPLACE"*
>
> The attached self-contained testcase, "pg-bad-invalidation-bug.sql", seems
> to me definitely to demonstrate a bug. I've attached the spooled output as
> "pg-bad-invalidation-bug.txt" Do you agree that this is a bug?
>
Haven't experimented myself but the function declarations are themselves
wrong - they are not immutable.
Please use the information here to file it.
> What's the number of, and URL to, the newly-filed bug?
>
You've just filed a bug report. Since you did so directly instead of using
the form it doesn't get assigned a bug number. All email sent to this
list, or bugs filed using the form, get publicly posted to the mailing list
and are archived as described on the mailing list related web pages. This
is the permanent link for this thread in the archive:
https://www.postgresql.org/message-id/flat/4DE6C9D8-77A5-4858-82CB-18728F59D715%40yugabyte.com
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryn Llewellyn | 2020-10-13 01:15:21 | Re: Wrong results from function that selects from vier after "created or replace" |
| Previous Message | Tom Lane | 2020-10-13 00:38:10 | Re: Wrong results from function that selects from vier after "created or replace" |