Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't create unlogged table

Can't create unlogged table

From
Alexander Perepelica
Date:
Hi!
I try create unlogged table in 9.1beta3 (linux x86_64) execute such code:

create unlogged table public.test (
id serial primary key,
some_text text
);
and what I see is:

ERROR:  only temporary relations may be created in temporary schemas
What I do wrong?

Thank you,
Alexander

Re: Can't create unlogged table

From
Joshua Berkus
Date:
Alexander,

I don't know, that looks like a bug.  Robert?

--Josh

----- Original Message -----
>
> Hi!
> I try create unlogged table in 9.1beta3 (linux x86_64) execute such
> code:
>
> create unlogged table public .test (
> id serial primary key ,
> some_text text );
> and what I see is:
>
> ERROR:  only temporary relations may be created in temporary schemas
> What I do wrong?
>
> Thank you,
> Alexander
>

Re: Can't create unlogged table

From
Robert Haas
Date:
On Sat, Aug 13, 2011 at 12:13 PM, Joshua Berkus <josh@agliodbs.com> wrote:
> I don't know, that looks like a bug.  Robert?

Yeah, it's a bug; further, it's a bug I introduced through poor testing.

It's already fixed in the tip of REL9_1_STABLE.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company