Subject: Plperlu function & backticks return value -> truncated?
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 13 Oct 2004 17:07:05 +0200
Message-ID: <6C0CF58A187DA5479245E0830AF84F42142C54@poweredge.attiksystem.ch>
content-class: urn:content-classes:message
Thread-Topic: Plperlu function & backticks return value -> truncated?
Thread-Index: AcSxNkzrWb3cXSFBRaaiNHKWXamJRg==
From: "Philippe Lang" <philippe.lang@attiksystem.ch>
To: <pgsql-sql@postgresql.org>

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 =3D `ps -afux | grep postgres`;
  @fields =3D 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?


Philippe

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

------------------------------------------------------------
--  UTILITY FUNCTION: ps
------------------------------------------------------------
CREATE FUNCTION public.ps()
  RETURNS text[] AS
'
  $ps =3D `ps -afux | grep postgres`;
  @fields =3D split /\n/, $ps;
  return "{" . join(",", @fields) . "}";
'
  LANGUAGE 'plperlu' VOLATILE;

------------------------------------------------------------
--  UTILITY FUNCTION: show_users
------------------------------------------------------------
CREATE FUNCTION public.show_users()
  RETURNS SETOF user_type AS
'
DECLARE
  users        text[];
  user_rec     line_type%ROWTYPE;
  i            int2;

BEGIN
  users =3D ps();

  FOR i IN 1 .. array_upper(users, 1) LOOP

    user_rec.line =3D users[i];
    RETURN NEXT user_rec;

  END LOOP;

  RETURN;
END
'
  LANGUAGE 'plpgsql' VOLATILE;

------------------------------------------------------------
--  MAIN
------------------------------------------------------------
select * from show_users();