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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".
Дата
Msg-id CAKFQuwa5zpmWp8L+6cdF=-uKQeW+VQhb+eOx_4J14y=RGv=zrA@mail.gmail.com
обсуждение исходный текст
Ответ на 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>)
Ответы 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>)
Список pgsql-bugs
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18064: Order of cascading deletes by foreign key; "on delete restrict"