مطالب مرتبط با «postgres function returning id» در back soft | نویسنده: استخدام کار
Postgres function returning wrong datatype
Vote count: 0 I am trying to install ubuntuone on a ubuntu server 15.04 and it seems there are a few things that aren't working anymore. The main problem I have is a query that is failing. Here is how it looks like: CREATE FUNCTION activity() RETURNS SETOF pg_stat_activity LANGUAGE sql SECURITY DEFINER SET search_path TO public AS $$ SELECT datid, datname, pid, usesysid, usename, application_name, client_addr, client_hostname, client_port, backend_start, xact_start, query_start, waiting, CASE WHEN query LIKE '%' OR query LIKE 'autovacuum:%' THEN query ELSE '' END AS current_query FROM pg_catalog.pg_stat_activity; $$; When I run it I get this error: ERROR: retu type mismatch in function decla...
ادامه مطلب
