Thread: trivial question about unlogged tables

trivial question about unlogged tables

From
jmscott@setspace.com
Date:
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




Re: trivial question about unlogged tables

From
Tom Lane
Date:
jmscott@setspace.com writes:
> pleasse pardon me for belaboring the obvious,
> but why is the following sql create statement failing in a 9.1beta3 psql.

It's a bug in beta3.

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=16a6a70ea

            regards, tom lane