Re: [HACKERS] 9.5.4: Segfault (signal 11) while running ALTER TABLE

2016-08-31 Thread Devrim Gündüz
Hi Tom, On Tue, 2016-08-30 at 08:18 -0400, Tom Lane wrote: > The above isn't ever likely to work for any large value of "work", > because the function would be confused about what the table rowtype > is.  I thought we had adequate defenses in there to throw an error > if you try to access a

Re: [HACKERS] 9.5.4: Segfault (signal 11) while running ALTER TABLE

2016-08-30 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= writes: > They wanted to change id column from uuid to int, so created this func first: > CREATE FUNCTION foofunc_id_uuidtoint(chartoconvert uuid) RETURNS integer > LANGUAGE sql IMMUTABLE STRICT > AS $_$ > SELECT newid FROM foo1 WHERE

[HACKERS] 9.5.4: Segfault (signal 11) while running ALTER TABLE

2016-08-30 Thread Devrim Gündüz
Hi, I received an email offlist about a crash that a non-customer experienced recently. I asked them to send a few details about the crash, so here it is. Please note that I don't have access to their systems, but they will be fast enough to provide data if needed. (They asked me to mask some of