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
>
>
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