BUG #6159: Can't create unlogged table
The following bug has been logged online:
Bug reference: 6159
Logged by: Alex
Email address: perepelica.alex@gmail.com
PostgreSQL version: 9.1beta3
Operating system: linux x86_64 archlinux
Description: Can't create unlogged table
Details:
Execute from pgadmin
create unlogged table public.test (
id serial primary key,
some_text text
);
And get such error
ERROR: only temporary relations may be created in temporary schemas
On Thu, 2011-08-11 at 14:19 +0000, Alex wrote:
create unlogged table public.test (
id serial primary key,
some_text text
);And get such error
ERROR: only temporary relations may be created in temporary schemas
IIRC it was fixed in post-beta3. Robert?
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
2011/8/11 Devrim GÜNDÜZ <devrim@gunduz.org>:
On Thu, 2011-08-11 at 14:19 +0000, Alex wrote:
create unlogged table public.test (
id serial primary key,
some_text text
);And get such error
ERROR: only temporary relations may be created in temporary schemas
IIRC it was fixed in post-beta3. Robert?
Yeah, sorry about that. I really booted that one, but it was fixed
July 21st on REL9_1_STABLE.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company