search

googlecodelabs / feedback

Provide feedback to our codelabs by filing an issue here
18 stars 22 forks source link

[smart-shop-agent-alloydb] #1434

Closed mrtushartiwari closed 2 months ago

mrtushartiwari commented 2 months ago

https://codelabs.developers.google.com/smart-shop-agent-alloydb#3 In step 4 [Schema and Data Ingestion] While creating the table gets the following error

using the same command as given in lab

CREATE TABLE apparels ( id BIGINT, category VARCHAR(100), sub_category VARCHAR(50), uri VARCHAR(200), image VARCHAR(100), content VARCHAR(2000), pdt_desc VARCHAR(5000), embedding vector(768) );

postgresql error: type "vector" does not exist

mrtushartiwari commented 2 months ago

Solution found please run CREATE EXTENSION vector;

before running create table command.