I have a function created as follows:
CREATE LANGUAGE plpythonu;
CREATE OR REPLACE FUNCTION unpickle (data text)
RETURNS text[]
AS $$
import base64
import pickle
return pickle.loads(base64.b64decode(data))
$$ LANGUAGE plpythonu IMMUTABLE;
CREATE INDEX issues_unpickle_tags_index ON issue USING btree (unpickle(tags));
I am getting an error when creating the index as - ERROR: function unpickle(text[]) does not exist.
The structure of table is like this:
CREATE TABLE "issue" (
"id" int4 DEFAULT nextval('issue_id_seq'::regclass) NOT NULL,
"tags" text[] COLLATE "default",
"description" text COLLATE "default" NOT NULL
)
I tried changing the first part to
CREATE OR REPLACE FUNCTION unpickle (data text[])
RETURNS text[]
Then get the error - ERROR: TypeError: must be string or buffer, not list
What am I doing wrong here.
b64decodeis expecting a string and you are passing a list of strings. Now what is really important is what are you trying to do?!!! Saving pickled data in an array? It does not make sense. – Clodoaldo Neto Aug 4 '14 at 17:49tags. Why do you think that thetagstext array is pickled? Post the function that saves data to theissuetable. – Clodoaldo Neto Aug 5 '14 at 12:47