Re: Plperlu function & backticks return value -> truncated?

Philippe Lang wrote:
> Hello,
>
> I'm using the following show_users() function in order to retreive in
> postgresql the output from the unix "ps" command.
>
> When run directly from a shell, this code:
>
> $ps = `ps -afux | grep postgres`;
> @fields = split /\n/, $ps;
> return "{" . join(",", @fields) . "}";
>
> ... runs fine.
>
> But when run inside a plperlu function, lines are being truncated after
> a certain width.
>
> Is that a known limitation of plperlu? Or maybe something else?

Depends if user_type is just a typo...

> ------------------------------------------------------------
> -- TYPE: line_type
> ------------------------------------------------------------
> CREATE TYPE public.line_type AS
> (
> line text
> );

> CREATE FUNCTION public.show_users()
> RETURNS SETOF user_type AS

> user_rec line_type%ROWTYPE;

--
Richard Huxton
Archonet Ltd