Problem with creating Create_Function_GetCacheItemFormat.sql

[artzie92]

Hi,
There is an error during executing the Create_Function_GetCacheItemFormat.sql script:

NOTICE: identifier "TABLE(distcache_id text, distcache_value bytea, distcache_expiresattime timestamp with time zone, distcache_slidingexpirationinseconds bigint, distcache_absoluteexpiration timestamp with time zone)" will be truncated to "TABLE(distcache_id text, distcache_value bytea, distcache_expir"

ERROR: type "TABLE(distcache_id text, distcache_value bytea, distcache_expir" does not exist
SQL state: 42704

Regards

[wullemsb]

I'll look into it...

[ZedZipDev]

My fix:

CREATE OR REPLACE FUNCTION public.getcacheitemformat(
	"SchemaName" text,
	"TableName" text,
	"DistCacheId" text,
	"UtcNow" timestamp with time zone)
    --RETURNS SETOF "TABLE(distcache_id text, distcache_value bytea, distcache_expiresattime timestamp with time zone, distcache_slidingexpirationinseconds bigint, distcache_absoluteexpiration timestamp with time zone)"
	RETURNS TABLE(distcache_id text, distcache_value bytea, distcache_expiresattime timestamp with time zone, distcache_slidingexpirationinseconds bigint, distcache_absoluteexpiration timestamp with time zone)	
    LANGUAGE 'plpgsql'
    COST 100.0
    VOLATILE NOT LEAKPROOF 
    ROWS 1000.0
AS $function$
...