Re: In processing DDL, when does pg_catalog get updated?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ken Winter" <ken(at)sunward(dot)org>
Cc: "'PostgreSQL pg-general List'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: In processing DDL, when does pg_catalog get updated?
Date: 2005-12-30 04:39:46
Message-ID: 8260.1135917586@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ken Winter" <ken(at)sunward(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ilja Golshtein 2005-12-30 09:02:59 Hang investigation
Previous Message Ken Winter 2005-12-30 04:13:07 In processing DDL, when does pg_catalog get updated?