Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8K8Uie48856 for ; Thu, 20 Sep 2001 04:30:44 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id KAA25659; Thu, 20 Sep 2001 10:30:32 +0200 (METDST) From: Haller Christoph Message-Id: <200109200829.KAA25055@rodos> Subject: Re: Registring a C function in PostgreSQL II To: iafmgc@unileon.es (=?iso-8859-1?Q?Miguel_Gonz=E1lez?=) Date: Thu, 20 Sep 2001 10:29:39 METDST Cc: pgsql-sql@postgresql.org In-Reply-To: <001501c14138$3af36c10$1301a8c0@uimagen>; from "=?iso-8859-1?Q?Miguel_Gonz=E1lez?=" at Sep 19, 101 9:09 pm X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200109/165 X-Sequence-Number: 4846 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 > >