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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: In processing DDL, when does pg_catalog get updated?
Дата
Msg-id 8260.1135917586@sss.pgh.pa.us
обсуждение исходный текст
Ответ на In processing DDL, when does pg_catalog get updated?  ("Ken Winter" <ken@sunward.org>)
Ответы Re: In processing DDL, when does pg_catalog get updated?  ("Ken Winter" <ken@sunward.org>)
Список 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 по дате отправления:

Предыдущее
От: "Ken Winter"
Дата:
Сообщение: In processing DDL, when does pg_catalog get updated?
Следующее
От: "Ilja Golshtein"
Дата:
Сообщение: Hang investigation