Thread: 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=DCND=DCZ <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: =A0only 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. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company