On Wed, Sep 21, 2011 at 11:35 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Sun, Sep 18, 2011 at 5:10 PM, Robert Haas wrote:
>>> On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane wrote:
In that case I'm betting Robert broke it somewhere in the unlogged-table
changes.
>
>>> Yeah, looks like
Robert Haas writes:
> On Sun, Sep 18, 2011 at 5:10 PM, Robert Haas wrote:
>> On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane 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
On Sun, Sep 18, 2011 at 5:10 PM, Robert Haas wrote:
> On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane wrote:
>> Alvaro Herrera writes:
>>> Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33
>>> -0300 2011:
_n_srv=# create table pg_temp.c (x int);
CREATE TABLE
On Thu, Sep 15, 2011 at 12:05 AM, Tom Lane wrote:
> Alvaro Herrera writes:
>> Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33
>> -0300 2011:
>>> _n_srv=# create table pg_temp.c (x int);
>>> CREATE TABLE
>>> _n_srv=# drop table pg_temp.c;
>>> DROP TABLE
>>> _n_srv=# cr
Alvaro Herrera writes:
> Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33
> -0300 2011:
>> _n_srv=# create table pg_temp.c (x int);
>> CREATE TABLE
>> _n_srv=# drop table pg_temp.c;
>> DROP TABLE
>> _n_srv=# create table pg_temp.c (x int unique);
>> ERROR: temporary t
On Wed, Sep 14, 2011 at 4:49 PM, Alvaro Herrera
wrote:
>
> Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33
> -0300 2011:
>
>> Cannot create temporary tables without using CREATE TEMP,
>> if I hardcode 'pg_temp' as a schema _and_ the table uses
>> a unique constraint on
Excerpts from Abel Abraham Camarillo Ojeda's message of mié sep 14 18:33:33
-0300 2011:
> Cannot create temporary tables without using CREATE TEMP,
> if I hardcode 'pg_temp' as a schema _and_ the table uses
> a unique constraint on a column, this does work if the table
> doesn't use a unique con
The following bug has been logged online:
Bug reference: 6205
Logged by: Abel Abraham Camarillo Ojeda
Email address: acam...@verlet.org
PostgreSQL version: 9.1.0
Operating system: OpenBSD-current/amd64
Description:ERROR: temporary tables cannot specify a schema name
