Re: possible issue with array type created for every heap relation composite type

2018-07-10 Thread Tom Lane
Jimmy Yih writes: > The possible issue I would like to note is related to how the array type is > named in makeArrayTypeName() function. The composite type will take the > heap relation's relname as its typname and the array type will usually be > named with an underscore prepended (after first

possible issue with array type created for every heap relation composite type

2018-07-10 Thread Jimmy Yih
Hello, In Postgres 8.3, it was decided that an array type would be automatically created for every heap relation's composite type. Reference thread: https://www.postgresql.org/message-id/flat/20070302234016.GF3665%40fetter.org The possible issue I would like to note is related to how the array