Assertion failure on UNLOGGED VIEW and SEQUENCE

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Assertion failure on UNLOGGED VIEW and SEQUENCE
Date: 2011-02-18 11:42:50
Message-ID: AANLkTinVU_Ax5AWiF=rY4sGQxZ+BpmRcpL2Do340uNXh@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

UNLOGGED is defigned in OptTemp in gram.y, so the parser accepts
CREATE UNLOGGED VIEW and CREATE UNLOGGED SEQUENCE, but they are
actually not supported.

=# CREATE UNLOGGED VIEW uv AS SELECT 1;
TRAP: FailedAssertion("!(relkind == 'r' || relkind == 't')", File:
"heap.c", Line: 1246)

=# CREATE UNLOGGED SEQUENCE us;
TRAP: FailedAssertion("!(relkind == 'r' || relkind == 't')", File:
"heap.c", Line: 1246)

The most easiest fix would be preventing them in parser level.

--
Itagaki Takahiro

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-02-18 11:50:58 Server Name
Previous Message Peter Eisentraut 2011-02-18 11:35:16 Re: ALTER TYPE COLLATABLE?