Re: BUG #15327: postgres segfaults on ALTER FUNCTION ... SET SCHEMA ...

From: Kai Kratz <kai(dot)kratz(at)googlemail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15327: postgres segfaults on ALTER FUNCTION ... SET SCHEMA ...
Date: 2018-08-15 14:08:51
Message-ID: CAMJyv-4aMLee-YyzyEAzF9vCCnATrWd3zjWj3toznOE=B2MomA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks for the very fast feedback,

It seems that I have an issue with an FDW extension that was loaded,
it didn't cross my mind that this could interfere with ALTER FUNCTION.
Same is true for the other 2 bug I filed a couple of minutes ago.

I am terribly sorry for creating unnecessary noise on pgsql-bugs. :(

Cheers
Kai Kratz
On Wed, Aug 15, 2018 at 3:41 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> =?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> > pg-user=# CREATE SCHEMA test_schema;
> > CREATE SCHEMA
> > pg-user=# CREATE FUNCTION custom_eq(int, int)
> > RETURNS BOOL
> > LANGUAGE SQL IMMUTABLE AS
> > $$
> > SELECT $1 = $2;
> > $$;
> > CREATE FUNCTION
> > pg-user=# ALTER FUNCTION custom_eq(int, int) SET SCHEMA test_schema;
> > server closed the connection unexpectedly
>
> Huh. Works fine for me. Is the server you're using custom-built?
> If so, what build options did you use? If not, where did you get
> it from? In either case, the output of pg_config might be useful.
>
> regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2018-08-15 15:19:40 Re: BUG #15327: postgres segfaults on ALTER FUNCTION ... SET SCHEMA ...
Previous Message PG Bug reporting form 2018-08-15 13:46:29 BUG #15329: postgres segfaults on ALTER DOMAIN ... SET SCHEMA ...