Re: In processing DDL, when does pg_catalog get updated? - Mailing list pgsql-general

From Tom Lane
Subject Re: In processing DDL, when does pg_catalog get updated?
Date
Msg-id 8260.1135917586@sss.pgh.pa.us
Whole thread Raw
In response to In processing DDL, when does pg_catalog get updated?  ("Ken Winter" <ken@sunward.org>)
Responses Re: In processing DDL, when does pg_catalog get updated?
List pgsql-general
"Ken Winter" <ken@sunward.org> writes:
> Is it possible that the pg_catalog is not updated with the results of a DDL
> script until the whole script has executed?

No, the serial sequence should exist as soon as the CREATE TABLE is done
... unless you are doing something weird like wrapping the whole thing
in a transaction and expecting uncommitted transaction results to be
visible from another session.  Could you show us a complete test case
instead of an extract?

            regards, tom lane

pgsql-general by date:

Previous
From: "Ken Winter"
Date:
Subject: In processing DDL, when does pg_catalog get updated?
Next
From: "Ilja Golshtein"
Date:
Subject: Hang investigation