search

postgrespro / imgsmlr

Similar images search for PostgreSQL
Other
257 stars 41 forks source link

ERROR: function jpeg2pattern(bytea) does not exist #5

Closed elesos closed 6 years ago

elesos commented 6 years ago

when i excute this sql:

CREATE TABLE pat AS ( SELECT id, shuffle_pattern(pattern) AS pattern, pattern2signature(pattern) AS signature FROM ( SELECT id, jpeg2pattern(data) AS pattern FROM image ) x );

get this error msg:

ERROR: function jpeg2pattern(bytea) does not exist

does anybody know why?thank you.

elesos commented 6 years ago

problem solved: psql -U postgres -d exampledb -h 127.0.0.1 -p 5432 then exeute the sql.