CTAS command tags

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: CTAS command tags
Date: 2021-01-22 13:14:29
Message-ID: 3080443e-5a88-6709-13c7-7b20ddf590a0@postgresfriends.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was recently surprised by the following inconsistencies in returned
command tags for CTAS:

postgres=# create table a as select 123;
SELECT 1

postgres=# create table b as select 123 with data;
SELECT 1

postgres=# create table c as select 123 with no data;
CREATE TABLE AS

Shouldn't we make the first two tags (which are likely the same code
path; I haven't looked) the same as the third? I can look into writing
the patch if desired.
--
Vik Fearing

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2021-01-22 13:14:40 Re: [PATCH] Keeps tracking the uniqueness with UniqueKey
Previous Message Fujii Masao 2021-01-22 13:13:04 Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit