pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can't create unlogged table
3+ messages / 3 participants
[nested] [flat]

* Can't create unlogged table
@ 2011-08-11 14:22 Alexander Perepelica <alexondi@rambler.ru>
  2011-08-13 16:13 ` Re: Can't create unlogged table Joshua Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Alexander Perepelica @ 2011-08-11 14:22 UTC (permalink / raw)
  To: pgsql-testers

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can't create unlogged table
  2011-08-11 14:22 Can't create unlogged table Alexander Perepelica <alexondi@rambler.ru>
@ 2011-08-13 16:13 ` Joshua Berkus <josh@agliodbs.com>
  2011-08-13 19:26   ` Re: Can't create unlogged table Robert Haas <robertmhaas@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Joshua Berkus @ 2011-08-13 16:13 UTC (permalink / raw)
  To: Alexander Perepelica <alexondi@rambler.ru>; Robert Haas <robertmhaas@gmail.com>; +Cc: pgsql-testers

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
> 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can't create unlogged table
  2011-08-11 14:22 Can't create unlogged table Alexander Perepelica <alexondi@rambler.ru>
  2011-08-13 16:13 ` Re: Can't create unlogged table Joshua Berkus <josh@agliodbs.com>
@ 2011-08-13 19:26   ` Robert Haas <robertmhaas@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Robert Haas @ 2011-08-13 19:26 UTC (permalink / raw)
  To: Joshua Berkus <josh@agliodbs.com>; +Cc: Alexander Perepelica <alexondi@rambler.ru>; pgsql-testers

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2011-08-13 19:26 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-11 14:22 Can't create unlogged table Alexander Perepelica <alexondi@rambler.ru>
2011-08-13 16:13 ` Joshua Berkus <josh@agliodbs.com>
2011-08-13 19:26   ` Robert Haas <robertmhaas@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox