Is there way to detect uncommitted 'new table' in pg_class?

From: Hubert Zhang <hzhang(at)pivotal(dot)io>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Is there way to detect uncommitted 'new table' in pg_class?
Date: 2018-10-31 10:04:41
Message-ID: CAB0yrennBDdoW=nwsGd-v=QPpL4XqKKJ7RrOrdfJnZNGKmpoWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Dolgov 2018-10-31 10:34:59 Re: Pluggable Storage - Andres's take
Previous Message Nikolay Shaplov 2018-10-31 08:40:48 Re: [PATCH][PROPOSAL] Add enum releation option type