Home > mailing lists

Is there way to detect uncommitted 'new table' in pg_class? - Mailing list pgsql-hackers

From	Hubert Zhang
Subject	Is there way to detect uncommitted 'new table' in pg_class?
Date	October 31, 2018 13:04:41
Msg-id	CAB0yrennBDdoW=nwsGd-v=QPpL4XqKKJ7RrOrdfJnZNGKmpoWA@mail.gmail.com Whole thread Raw
Responses	Re: Is there way to detect uncommitted 'new table' in pg_class? (Robert Haas <robertmhaas@gmail.com>)
List	pgsql-hackers

Hi all,

In PG READ UNCOMMITTED is treated as READ COMMITTED

But I have a requirement to read dirty table. Is there way to detect table which is created in other uncommitted transaction?

T1:

BEGIN;

create table a(i int);

T2:

select * from pg_class where relname='a';

could return table a?

Thanks

Hubert Zhang

From: Nikolay Shaplov
Date: 31 October 2018, 11:40:48
Subject: Re: [PATCH][PROPOSAL] Add enum releation option type

From: Dmitry Dolgov
Date: 31 October 2018, 13:34:59
Subject: Re: Pluggable Storage - Andres's take