face-postgre icon indicating copy to clipboard operation
face-postgre copied to clipboard

Problem with FaceFind

Open chen716 opened this issue 6 years ago • 3 comments

Hi I'm trying to integrate with psycopg2, and I have successfully added the faces into vector table. But when I try to run the find faces, this issue showed up:

syntax error at or near ")" LINE 1: ...08222115784883499]) <-> vec_high, 2)) <-> vec_high) ASC LIMI...

If I fix the extra bracket this shows up

operator does not exist: double precision <-> cube LINE 1: ...0706567764,0.08222115784883499]) <-> vec_high, 2) <-> vec_hi...

do you have any idea how to fix this? Please help thanks

chen716 avatar Jun 19 '18 14:06 chen716

Same issue here!

cesarandreslopez avatar Jun 29 '18 17:06 cesarandreslopez

Same issue here.

Tested on PG 9.6.6 and PG 9.5.13

breim avatar Jul 03 '18 08:07 breim

@chen716 and @cesarandreslopez .

Try this fork: https://github.com/d-demirci/face-postgre

He is using lib psycopg2 instead lib postgresql. You must install psycopg2 before. So just run: pip3 install psycopg2

breim avatar Jul 03 '18 09:07 breim