Re: BUG #16758: create temporary table with the same name loses defaults, indexes

As a followup, if I change the name to something different from the original, like 'xy', it works as expected.

> On 1 Dec 2020, at 15:09, PG Bug reporting form <noreply@postgresql.org> wrote:
> 
> The following bug has been logged on the website:
> 
> Bug reference:      16758
> Logged by:          Marc Boeren
> Email address:      marc@guidance.nl
> PostgreSQL version: 12.5
> Operating system:   macOS / docker-debian / CentOR
> Description:        
> 
> In 12.5 (and later), in a clean, empty database (in this case the default
> 12.5 docker image), when I execute the following lines:
> 
>    create table xx (name text NOT NULL default '', PRIMARY KEY(name));
> 
>    create temporary table xx
>        (like xx including DEFAULTS including CONSTRAINTS including
> INDEXES);
> 
>    select c.relname, n.nspname
>    from pg_namespace n
>      join pg_class   c on n.oid=c.relnamespace
>    where (c.relname LIKE 'x%') order by n.nspname, c.relname;
> 
> I get this:
> 
>    relname   nspname
>    "xx"      "pg_temp_8"
>    "xx"      "public"
>    "xx_pkey" "public"
> 
> I expected the primary key to be copied too. Comparing the results from 12.4
> (and earlier versions):
> 
>    relname   nspname
>    "xx"      "pg_temp_8"
>    "xx_pkey" "pg_temp_8"
>    "xx"      "public"
>    "xx_pkey" "public"
> 
> I couldn't find anything in the changelog for 12.5 that indicates it is
> intentional. I checked against 13.1 too, same problem.
> The actual table is a bit larger (about 100 fields, no relations) and loses
> the primary key and all indexes and defaults since 12.5. The SQL above is
> the shortest form that demonstrates the issue.
> 
> Thanks, Marc
>