trivial question about unlogged tables

From: jmscott(at)setspace(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: trivial question about unlogged tables
Date: 2011-08-13 03:58:26
Message-ID: 61356.76.183.20.251.1313207906.squirrel@panoz.setspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

pleasse pardon me for belaboring the obvious,
but why is the following sql create statement failing in a 9.1beta3 psql.

postgres(at)nocdb> psql --version
psql (PostgreSQL) 9.1beta3
contains support for command-line editing

postgres(at)nocdb> cat t.sql
create unlogged table t
(
x int
);

postgres(at)nocdb> psql -f t.sql
psql:t.sql:4: ERROR: only temporary relations may be created in temporary
schemas

-j

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2011-08-13 14:15:45 Re: trivial question about unlogged tables
Previous Message raghu ram 2011-08-12 19:35:28 Re: Alter table to add foreign key