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 > [EMAIL PROTECTED] > > 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 > >
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
