From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Carlos Peralta Ramirez <cperalta(at)hera(dot)inf(dot)ucv(dot)cl> |
Cc: | pgsql-novice <pgsql-novice(at)hub(dot)org>, pgsql-sql <pgsql-sql(at)postgreSQL(dot)org>, pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [SQL] Functions for arrays !!!! |
Date: | 1999-05-08 14:49:18 |
Message-ID: | 18888.926174958@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Carlos Peralta Ramirez <cperalta(at)hera(dot)inf(dot)ucv(dot)cl> writes:
> I create the function in PostgreSQL ->
> dbtest=>create function tester(_int4,int4) returns bool as
> '$path/tester.so' language 'c';
> CREATE
> But when try to use it, ->
> dbtest=>select tester('{1,2,3,4}',3);
> ERROR: stat failed on file tester.so
> I dont know whats happens !!!!!
Looks like Postgres couldn't find the .so file to load it.
(The error message is sadly incomplete --- maybe I'll look to see
if it can be improved.)
When you wrote '$path/tester.so' above, were you being literal or
did you mean to indicate that you filled in an appropriate path?
All the examples you might see of that notation in Postgres are
in shell scripts where a variable like $path will get expanded;
if you typed it in by hand then you have to supply the complete
path by hand. Look at the entry for the tester function in the
pg_proc table to see what pathname the system has recorded...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Drabble | 1999-05-08 14:54:39 | Re: [GENERAL] postmaster(server) and psql(client) question. |
Previous Message | Neil Burrows | 1999-05-08 11:13:27 | Version of a Postgres installation |
From | Date | Subject | |
---|---|---|---|
Next Message | Henrik Steffen | 1999-05-08 16:58:43 | TRANSLATE() |
Previous Message | Carlos Peralta Ramirez | 1999-05-07 14:56:44 | Functions for arrays !!!! |