Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data
Дата
Msg-id YtC+Iamgwpm7gUYu@momjian.us
обсуждение исходный текст
Ответ на CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
On Wed, Feb  9, 2022 at 01:02:51PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/14/sql-createtableas.html
> Description:
> 
> If I create a table with CREATE TABLE IF NOT EXISTS table_name AS, and the
> table exists already, I get a NOTICE instead of an ERROR.
> 
> I wanted to have it clarified explicitly that the data from the SELECT
> statement is ignored in this case.

Good point.  Attached is a documentation patch to clarify this.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson


Вложения

В списке pgsql-docs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: "Restore" vs. "Reload"
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data