BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: dnsl48(at)gmail(dot)com
Subject: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
Date: 2019-02-11 17:43:13
Message-ID: 15631-188663b383e1e697@postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15631
Logged by: Serge Latyntsev
Email address: dnsl48(at)gmail(dot)com
PostgreSQL version: 11.1
Operating system: Alpine
Description:

When using `generated by default as identity` in a temporary table with `on
commit drop`, but without starting a transaction, system catalogs get
corrupted and won't let create temporary tables anymore.

Here's how to reproduce (within a docker container):

$ docker exec -it $(docker run -d --rm postgres:11.1-alpine) bash
# psql postgres postgres
# create temporary table foo ( bar int generated by default as identity ) on
commit drop;
CREATE TABLE
# \q
# psql postgres postgres
# create temporary table a (b varchar);
ERROR: could not open relation with OID 16388
LINE 1: create temporary table a (b varchar);

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-02-11 17:55:07 BUG #15632: Correctly escaped strings are mishandled in function
Previous Message Amit Langote 2019-02-11 13:18:56 Re: BUG #15629: Typo in Documentation