Skip site navigation (1) Skip section navigation (2)

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

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Plperlu function & backticks return value -> truncated?
Date: 2004-10-13 15:54:31
Message-ID: 6C0CF58A187DA5479245E0830AF84F42142C56@poweredge.attiksystem.ch (view raw or flat)
Thread:
Lists: pgsql-sql
Thanks! That's perfect... `ps -awfux | grep postgres` runs fine...

-----Message d'origine-----
De : Michael Fuhr [mailto:mike(at)fuhr(dot)org] 
Envoyé : mercredi, 13. octobre 2004 17:47
À : Philippe Lang
Cc : pgsql-sql(at)postgresql(dot)org
Objet : Re: [SQL] Plperlu function & backticks return value -> truncated?

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 being truncated 
> after a certain width.

Many versions of ps truncate lines at a certain length if they can't determine the terminal size.  Since you're running ps from inside the backend, there's probably no terminal to check.  Check the ps manual page to see if it supports an option like -w (or multiple occurrences of -w) to increase the line length.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date

Next:From: sadDate: 2004-10-14 12:34:22
Subject: libpq-fe: PQgetvalue() ?
Previous:From: Michael FuhrDate: 2004-10-13 15:47:13
Subject: Re: Plperlu function & backticks return value -> truncated?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group