Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tuesday, August 22, 2023, PG Bug reporting form <noreply(at)postgresql(dot)org>
> wrote:
>> When I run:
>> create table if not exists "vector" ();
>> alter table "vector" add column if not exists "fz_vector1_embedding"
>> vector(1536);
>> I got an error:
>> ERROR: type modifier is not allowed for type "vector"
>> LINE 1: ..." add column if not exists "fz_vector1_embedding" vector(153...

> You are in the wrong place, core doesn’t have this type.

I think it's basically a search path problem: the table's composite type
"vector" is masking the extension's type. Try schema-qualifying "vector"
with the appropriate schema name.

regards, tom lane