sternix

### What steps will reproduce the problem? run script belove with psql ### What is the expected result? Success ### What do you get instead? Failure with ``` psql:a.sql:38: ERROR:...

Hi @marcovtwout i copied the sql below https://github.com/yiisoft/yii/blob/master/framework/db/schema/pgsql/CPgsqlSchema.php#L233 for testing, i read the release notes can't see directly related for this issue,

Hi, my script run with ``` contype::char, ``` cast contype from "char" to char https://github.com/yiisoft/yii/blob/master/framework/db/schema/pgsql/CPgsqlSchema.php#L242 it worked PostgreSQL 14.3, 14.5 and 15.0 versions.

Hi, from https://www.postgresql.org/docs/current/datatype-character.html > The type "char" (note the quotes) is different from char(1) in that it only uses one byte of storage, and therefore can store only a single...

Hi, can be tested with, ``` create table tbla ( a "char" ); create table tblb ( b char(1) ); insert into tbla values ('a'); insert into tbla values ('b');...

Hi, mailed this error to PostgreSQL mailing list, i have reply below, https://www.postgresql.org/message-id/8bd63f844a2319a0199f09cfb424a7089587e264.camel%40cybertec.at > Yes, it is. See this paragraph from the release notes > (https://www.postgresql.org/docs/current/release-15.html#id-1.11.6.5.5.13): > > - Create...

Hi @marcovtwout , thank you for reply, yes #4511 solved my issue,