Thread

1. Pg module "eats" environment

   Vitaly Piniygin <gambler@pfr.ru> — 1999-10-12T09:12:33Z

   Your name               :  Vitaly Piniygin      
   Your email address      :  <gambler@pfr.ru>
   
   
   System Configuration
   ---------------------
     Architecture:
     Operating System:
   
   Linux 2.2.9 i686 unknown
   
   FreeBSD 3.2-RELEASE i386
   
     PostgreSQL version:   PostgreSQL-6.5.1
   
     Compiler used (example:  gcc 2.8.0):
   linux:
   gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
   fbsd:
   gcc version 2.7.2.1
   
   Please enter a FULL description of your problem:
   ------------------------------------------------
   
           The Pg perl module seems to be broken in following way:
   It "eats" environment after the database is opened and $0 perl variable is set
   to some value ( see the script below).
   
   
   
   Please describe a way to repeat the problem.   Please try to provide a
   concise reproducible example, if at all possible: 
   ----------------------------------------------------------------------
   
   ~ $ export | grep PG
   declare -x PGDATABASE="test"
   declare -x PGHOST="host"
   declare -x PGLIB="/usr/local/pgsql/lib"
   declare -x PGPASSWORD="passwd"
   declare -x PGUSER="user"
   ~ $ perl -e 'use Pg; $dbconn = Pg::connectdb(""); $0 = "name";\
   system("echo\$PGUSER:\$PGDATABASE");'
   :
   ~/projects/TD/assist $
   
   If you know how this problem might be fixed, list the solution below:
   ---------------------------------------------------------------------
   
           I'm a user, not perl-modules guru ;-)
   
   ----------------------------------
   
   BG, Vit
   
   E-Mail: Vitaly Piniygin <gambler@pfr.ru>
   Date: 12-Oct-99
   Time: 15:09:56
   
   ----------------------------------
   
   

2. Re: [BUGS] Pg module "eats" environment

   Edmund Mergl <e.mergl@bawue.de> — 1999-10-12T18:38:05Z

   Vitaly Piniygin wrote:
   > 
   > Your name               :  Vitaly Piniygin
   > Your email address      :  <gambler@pfr.ru>
   > 
   > System Configuration
   > ---------------------
   >   Architecture:
   >   Operating System:
   > 
   > Linux 2.2.9 i686 unknown
   > 
   > FreeBSD 3.2-RELEASE i386
   > 
   >   PostgreSQL version:   
   > 
   >   Compiler used (example:  gcc 2.8.0):
   > linux:
   > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
   > fbsd:
   > gcc version 2.7.2.1
   > 
   > Please enter a FULL description of your problem:
   > ------------------------------------------------
   > 
   >         The Pg perl module seems to be broken in following way:
   > It "eats" environment after the database is opened and $0 perl variable is set
   > to some value ( see the script below).
   > 
   > Please describe a way to repeat the problem.   Please try to provide a
   > concise reproducible example, if at all possible:
   > ----------------------------------------------------------------------
   > 
   > ~ $ export | grep PG
   > declare -x PGDATABASE="test"
   > declare -x PGHOST="host"
   > declare -x PGLIB="/usr/local/pgsql/lib"
   > declare -x PGPASSWORD="passwd"
   > declare -x PGUSER="user"
   > ~ $ perl -e 'use Pg; $dbconn = Pg::connectdb(""); $0 = "name";\
   > system("echo\$PGUSER:\$PGDATABASE");'
   > :
   > ~/projects/TD/assist $
   > 
   > If you know how this problem might be fixed, list the solution below:
   > ---------------------------------------------------------------------
   > 
   >         I'm a user, not perl-modules guru ;-)
   > 
   > ----------------------------------
   > 
   > BG, Vit
   > 
   > E-Mail: Vitaly Piniygin <gambler@pfr.ru>
   > Date: 12-Oct-99
   > Time: 15:09:56
   > 
   > ----------------------------------
   > 
   > ************
   
   
   this is on RH6.0 with PostgreSQL-6.5.2:
   
   mergl@sls> export | grep PG
   declare -x PGDATABASE="test"
   declare -x PGHOST="host"
   declare -x PGLIB="/usr/local/pgsql/lib"
   declare -x PGPASSWORD="passwd"
   declare -x PGPPATH="/home/mergl/pgp"
   declare -x PGUSER="user"
   mergl@sls> perl -e 'use Pg; $dbconn = Pg::connectdb(""); $0 = "name"; system("echo \$PGUSER:\$PGDATABASE");'
   user:test
   mergl@sls> 
   
   
   so it's not related to pgsql_perl5, it must be related to your environment.
   
   
   Edmund
   
   
   -- 
   Edmund Mergl
   mailto:E.Mergl@bawue.de
   http://www.bawue.de/~mergl
   
   

3. Re: [BUGS] Pg module "eats" environment

   Vitaly Piniygin <gambler@pfr.ru> — 1999-10-13T05:33:58Z

   
           Thanks for replay. It seems to be the 6.5.1-related bug,
   since it was observed in two different boxes/OS's/environments, with the only
   common part being postgres-6.5.1.
   
   ----------------------------------
   
   BG, Vit
   
   E-Mail: Vitaly Piniygin <gambler@pfr.ru>
   Date: 13-Oct-99
   Time: 11:33:33
   
   ----------------------------------
   
   
   On 12-Oct-99 Edmund Mergl wrote:
   > Vitaly Piniygin wrote:
   >> 
   >> Your name               :  Vitaly Piniygin
   >> Your email address      :  <gambler@pfr.ru>
   >> 
   >> System Configuration
   >> ---------------------
   >>   Architecture:
   >>   Operating System:
   >> 
   >> Linux 2.2.9 i686 unknown
   >> 
   >> FreeBSD 3.2-RELEASE i386
   >> 
   >>   PostgreSQL version:   
   >> 
   >>   Compiler used (example:  gcc 2.8.0):
   >> linux:
   >> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
   >> fbsd:
   >> gcc version 2.7.2.1
   >> 
   >> Please enter a FULL description of your problem:
   >> ------------------------------------------------
   >> 
   >>         The Pg perl module seems to be broken in following way:
   >> It "eats" environment after the database is opened and $0 perl variable is
   >> set
   >> to some value ( see the script below).
   >> 
   >> Please describe a way to repeat the problem.   Please try to provide a
   >> concise reproducible example, if at all possible:
   >> ----------------------------------------------------------------------
   >> 
   >> ~ $ export | grep PG
   >> declare -x PGDATABASE="test"
   >> declare -x PGHOST="host"
   >> declare -x PGLIB="/usr/local/pgsql/lib"
   >> declare -x PGPASSWORD="passwd"
   >> declare -x PGUSER="user"
   >> ~ $ perl -e 'use Pg; $dbconn = Pg::connectdb(""); $0 = "name";\
   >> system("echo\$PGUSER:\$PGDATABASE");'
   >> :
   >> ~/projects/TD/assist $
   >> 
   >> If you know how this problem might be fixed, list the solution below:
   >> ---------------------------------------------------------------------
   >> 
   >>         I'm a user, not perl-modules guru ;-)
   >> 
   >> ----------------------------------
   >> 
   >> BG, Vit
   >> 
   >> E-Mail: Vitaly Piniygin <gambler@pfr.ru>
   >> Date: 12-Oct-99
   >> Time: 15:09:56
   >> 
   >> ----------------------------------
   >> 
   >> ************
   > 
   > 
   > this is on RH6.0 with PostgreSQL-6.5.2:
   > 
   > mergl@sls> export | grep PG
   > declare -x PGDATABASE="test"
   > declare -x PGHOST="host"
   > declare -x PGLIB="/usr/local/pgsql/lib"
   > declare -x PGPASSWORD="passwd"
   > declare -x PGPPATH="/home/mergl/pgp"
   > declare -x PGUSER="user"
   > mergl@sls> perl -e 'use Pg; $dbconn = Pg::connectdb(""); $0 = "name";
   > system("echo \$PGUSER:\$PGDATABASE");'
   > user:test
   > mergl@sls> 
   > 
   > 
   > so it's not related to pgsql_perl5, it must be related to your environment.
   > 
   > 
   > Edmund
   >