Re: Lc_collate & lc_type? whitespace and nbsp unique index...

I assumed that the issue with the module which implements the mchar and
mvarchar types...
Thank you, Laurenz and Tom for your help.

вт, 13 июл. 2021 г., 23:43 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Ilmir Mulyukov <ilmir(dot)mulyukov(at)gmail(dot)com> writes:
> > Laurenz, there is no index for this table.
> > ka_im_pg=# \d _inforg31440
> > Table "public._inforg31440"
> > Column | Type | Collation | Nullable | Default
> > ---------------+---------------+-----------+----------+---------
> > _fld31441 | mvarchar(400) | | not null |
> > _fld31442 | mvarchar(10) | | not null |
> > _fld31443rref | bytea | | not null |
> > _fld2102 | numeric(7,0) | | not null |
>
> What in the world is type "mvarchar"? It's certainly not
> anything defined by core Postgres. I think you need to
> address this question to whoever wrote that datatype.
> It seems somewhat likely that this is intentional behavior
> for the type.
>
> regards, tom lane
>