Assertion failure on UNLOGGED VIEW and SEQUENCE - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Assertion failure on UNLOGGED VIEW and SEQUENCE
Date
Msg-id AANLkTinVU_Ax5AWiF=rY4sGQxZ+BpmRcpL2Do340uNXh@mail.gmail.com
Whole thread Raw
Responses Re: Assertion failure on UNLOGGED VIEW and SEQUENCE  (Robert Haas <robertmhaas@gmail.com>)
List 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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ALTER TYPE COLLATABLE?
Next
From: Simon Riggs
Date:
Subject: Server Name