Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".
Date
Msg-id CAKFQuwa5zpmWp8L+6cdF=-uKQeW+VQhb+eOx_4J14y=RGv=zrA@mail.gmail.com
Whole thread Raw
In response to BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view


On Tuesday, August 22, 2023, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18065
Logged by:          kaijian xu
Email address:      a17764530215@gmail.com
PostgreSQL version: 15.3
Operating system:   Debian GNU/Linux 11
Description:       

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.

David J.
 

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #18064: Order of cascading deletes by foreign key; "on delete restrict"