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
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) . "}";
..
Hello,
Yes, I made a typo, sorry. I've been playing with different types this afternoon,
that's why.
But "user_type" was also made up of a "text" field, just like "line_type", so the
problem is still here...
-Message d'origine-
De : Richard Huxton [mailto:[EMAIL PROTECTED]
Envoyé : mer
On Wed, Oct 13, 2004 at 05:07:05PM +0200, Philippe Lang wrote:
> 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
Thanks! That's perfect... `ps -awfux | grep postgres` runs fine...
-Message d'origine-
De : Michael Fuhr [mailto:[EMAIL PROTECTED]
Envoyé : mercredi, 13. octobre 2004 17:47
À : Philippe Lang
Cc : [EMAIL PROTECTED]
Objet : Re: [SQL] Plperlu function & backticks return value -> truncated?
