PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15631
PG Version11.1
OSAlpine
Opened2019-02-11 17:43:13+00
Reported bySerge Latyntsev
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15631
Logged by:          Serge Latyntsev
Email address:      (redacted)
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);

Messages

DateAuthorSubject
2019-02-11 17:43:13+00PG Bug reporting formBUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-11 20:33:08+00Tom LaneRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-12 14:00:34+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-12 14:27:50+00Tom LaneRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-13 02:38:17+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-13 04:41:05+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-14 01:30:06+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-15 13:02:58+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-15 14:43:59+00Tom LaneRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-15 16:03:29+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-16 00:13:08+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-02-16 04:32:04+00Tom LaneRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-03-08 11:00:40+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-03-09 01:35:57+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-03-11 20:41:14+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-03-12 03:46:30+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-03-13 09:28:11+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-03-26 02:45:27+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-04-25 00:59:24+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-04-26 13:07:54+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-04-26 15:09:36+00Tom LaneRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-04-27 00:10:18+00Michael PaquierRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs
2019-04-29 06:56:40+00Peter EisentrautRe: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs