pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Haller Christoph <ch@rodos.fzk.de>
To: iafmgc@unileon.es
Cc: pgsql-sql@postgresql.org
Subject: Re: Registring a C function in PostgreSQL II
Date: Thu, 20 Sep 2001 10:29:39 METDST
Message-ID: <200109200829.KAA25055@rodos> (raw)
In-Reply-To: <001501c14138$3af36c10$1301a8c0@uimagen>

My understanding is, if you have system calls from within 
postgres, the child processes invoked are run in the 
postgres user's environment. 
So, login as user postgres and have a look what aliases 
are set. My idea is, because postgres is not a human user, 
these aliases are not set. I think, if you copy the 
aliases from your environment to the postgres environment, 
you should be able to use them. 
But, I do not think it's a good idea to do so, because 
using such cross dependencies from the postgres environment 
to databank internals is prone to hard-to-find errors 
and makes porting applications to quite a hazard. 
Regards, Christoph 
> 
>  Thank you very much for your help.
> 
>   After being testing the program first from my prompt (it worked fine) and
>  then within PostgreSQL, I realized that I was using aliases for the system
>  users emails (for instance I used postgres instead of
>  postgres@myhost.mydomain.com
> 
>  once that i tried the "complete" email address it worked fine. Is it
>  possible to use aliases from within PostgreSQL (outside works fine, which
> is
>  something weird that I dont understand).
> 
>   Many thanks
> 
>   Miguel
> 
> 



view thread (3+ messages)  latest in thread

Message-ID: <200109200829.KAA25055@rodos>
Permalink:  ../200109200829.KAA25055@rodos/
Also on:    postgresql.org/message-id/200109200829.KAA25055@rodos

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ch@rodos.fzk.de, iafmgc@unileon.es
  Subject: Re: Registring a C function in PostgreSQL II
  In-Reply-To: <200109200829.KAA25055@rodos>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox