trivial question about unlogged tables - Mailing list pgsql-novice

From jmscott@setspace.com
Subject trivial question about unlogged tables
Date
Msg-id 61356.76.183.20.251.1313207906.squirrel@panoz.setspace.com
Whole thread Raw
Responses Re: trivial question about unlogged tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
pleasse pardon me for belaboring the obvious,
but why is the following sql create statement failing in a 9.1beta3 psql.

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

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

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

-j




pgsql-novice by date:

Previous
From: raghu ram
Date:
Subject: Re: Alter table to add foreign key
Next
From: Tom Lane
Date:
Subject: Re: trivial question about unlogged tables