Re: pgsql/src/backend/commands (creatinh.c)

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> tgl(at)postgresql(dot)org writes:
>> Change StoreCatalogInheritance() to work from a list of parent relation
>> OIDs rather than names. Aside from being simpler and faster, this way
>> doesn't blow up in the face of 'create temp table foo () inherits (foo)'.
>> Which is a rather odd thing to do, but it seems some people want to.

> Just wondering, is the "odd" thing here the 'temp', the empty column list,
> or 2 times "foo"?

The latter. The failure case was

create table foo (...);
create temp table foo (...) inherits (foo);

the problem being that the temp table name mapping for the temp foo
was installed before we were done looking up its ancestors.

regards, tom lane