Skip site navigation (1) Skip section navigation (2)

Re: BUG #6205: ERROR: temporary tables cannot specify a schema name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Abel Abraham Camarillo Ojeda <acamari(at)verlet(dot)org>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6205: ERROR: temporary tables cannot specify a schema name
Date: 2011-09-21 15:35:38
Message-ID: 23670.1316619338@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Sun, Sep 18, 2011 at 5:10 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> In that case I'm betting Robert broke it somewhere in the unlogged-table
>>> changes.

>> Yeah, looks like it. Will investigate.

> I committed a localized fix for this.  Basically, it now double-checks
> that the schema name isn't the one that would have been forced by the
> temp-ness, and doesn't throw an error if they match.

Keeping in mind that this worked before ... did you take the approach of
seeing exactly why it worked before, and why your changes broke it?
The patch you committed looked like it was introducing the functionality
from scratch, which should not have been the case.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-21 15:58:00
Subject: Re: BUG #6218: TRAP: FailedAssertion("!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)
Previous:From: YAMAMOTO TakashiDate: 2011-09-21 15:22:40
Subject: BUG #6218: TRAP: FailedAssertion("!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group