Change of behaviour for creating same type name in multiple schemas

Started by Dave Cramerover 2 years ago2 messages
#1Dave Cramer
davecramer@gmail.com

Greetings,

Before 16 if I created an array type in schema1 it would be named
schema1._array_type
if I created the same type in schema 2 it would have been named

schema2.__array_type

Can someone point me to where the code was changed ?

Thanks,
Dave Cramer

#2Matthias van de Meent
boekewurm+postgres@gmail.com
In reply to: Dave Cramer (#1)
Re: Change of behaviour for creating same type name in multiple schemas

On Thu, 5 Oct 2023 at 14:13, Dave Cramer <davecramer@gmail.com> wrote:

Greetings,

Before 16 if I created an array type in schema1 it would be named schema1._array_type
if I created the same type in schema 2 it would have been named

schema2.__array_type

Can someone point me to where the code was changed ?

This was with commit 70988b7b [0]https://github.com/postgres/postgres/commits/70988b7b0a0bd03c59a2314d0b5bcf2135692349 in July 2022, based on this thread
[1]: /messages/by-id/b84cd82c-cc67-198a-8b1c-60f44e1259ad@postgrespro.ru

Kind regards,

Matthias van de Meent
Neon (https://neon.tech)

[0]: https://github.com/postgres/postgres/commits/70988b7b0a0bd03c59a2314d0b5bcf2135692349
[1]: /messages/by-id/b84cd82c-cc67-198a-8b1c-60f44e1259ad@postgrespro.ru