| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | frank_limpert(at)yahoo(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data |
| Date: | 2022-07-15 01:08:49 |
| Message-ID: | YtC+Iamgwpm7gUYu@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
| Attachment | Content-Type | Size |
|---|---|---|
| exists.diff | text/x-diff | 830 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-07-15 01:47:19 | Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data |
| Previous Message | Bruce Momjian | 2022-07-14 23:42:43 | Re: "Restore" vs. "Reload" |