From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: "a17764530215@gmail.com" <a17764530215@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18065: An error occurred when attempting to add a column of
 type "vector" to a table named "vector".
In-reply-to: 
 <CAKFQuwa5zpmWp8L+6cdF=-uKQeW+VQhb+eOx_4J14y=RGv=zrA@mail.gmail.com>
References: <18065-006818db2efe479f@postgresql.org>
 <CAKFQuwa5zpmWp8L+6cdF=-uKQeW+VQhb+eOx_4J14y=RGv=zrA@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 22 Aug 2023 05:51:28 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3093015.1692710805.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Tue, 22 Aug 2023 09:26:45 -0400
Message-ID: <3093016.1692710805@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3093016.1692710805%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, August 22, 2023, PG Bug reporting form <noreply@postgresql.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