Re: Fwd: Core dump with nested CREATE TEMP TABLE

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fwd: Core dump with nested CREATE TEMP TABLE
Date: 2015-09-02 19:56:41
Message-ID: 55E75479.7040102@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 9/2/15 2:17 PM, Alvaro Herrera wrote:
> Michael Paquier wrote:
>
>> I haven't written yet a test case but I think that we could reproduce
>> that simply by having a relation referenced in the exception block of
>> a first function, calling a second function that itself raises an
>> exception, causing the referencing error.
>
> Hm, so function 2 is called in the exception block of function 1?
>
> Are you going to produce the test case for this? Jim?

I had attempted one but the issue is that it's more than just an
exception block thing. If it was that simple then we'd still get the
crash without involving pgTap. So I suspect you need to have a named
cursor in the mix as well.

Let me make another attempt at something simpler.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message dinesh kumar 2015-09-02 20:10:46 Re: Proposing COPY .. WITH PERMISSIVE
Previous Message Alvaro Herrera 2015-09-02 19:52:02 Re: Allow replication roles to use file access functions