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

2022-08-12 Thread Bruce Momjian
On Mon, Jul 18, 2022 at 03:43:03PM -0400, Bruce Momjian wrote: > fOn Thu, Jul 14, 2022 at 06:47:19PM -0700, David G. Johnston wrote: > > Not only is the existing table not modified, I think that the select query > > portion of the command is never even executed.  That would seem to be useful > > kn

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

2022-07-18 Thread Bruce Momjian
fOn Thu, Jul 14, 2022 at 06:47:19PM -0700, David G. Johnston wrote: > Not only is the existing table not modified, I think that the select query > portion of the command is never even executed.  That would seem to be useful > knowledge to have. > > Maybe something like: > > >  Do not throw an er

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

2022-07-14 Thread David G. Johnston
On Thu, Jul 14, 2022 at 6:08 PM Bruce Momjian wrote: > On Wed, Feb 9, 2022 at 01:02:51PM +, 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

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

2022-07-14 Thread Bruce Momjian
On Wed, Feb 9, 2022 at 01:02:51PM +, 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