Horton

Re: BUG #16730: Create table like with inheritance and self referencing index

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: sofoklis24@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2020-11-19T20:10:36Z
Lists: pgsql-bugs 
PG Bug reporting form <noreply@postgresql.org> writes:
> The following simplified example used to work on previous versions, but not
> on 10.15, we tested it again on version 10.11 and it works.

Hmph.  Apparently I was too careless about the order of execution of
the sub-commands created by a LIKE clause.

I pushed this patch:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=513db7b7004c8d1fa15dea4747a32cbc8f9621ef

which takes care of the particular case you show, but now I wonder
if there are other issues lurking nearby.  If you're in a position
to test this and see if it fixes your real application, please do.

Thanks for the report!

			regards, tom lane

Commits

  1. Further fixes for CREATE TABLE LIKE: cope with self-referential FKs.