From: | Juan Manuel Alvarez <naicigam(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Using a function in different schemas |
Date: | 2011-08-31 15:38:43 |
Message-ID: | CADj1=jSaChREYereBW0Z=OFjoJ=PNuEOt_=a5VqYZVhS7uJM2Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everyone! This is the first time I post on this list. Until now,
I was able to get a solution to all the problems I had, but now I am
facing an issue I can't resolve, so I hope you can help me.
The problem goes like this: I am using the same distribution of
tables/functions into different schemas, so I have the following
layout
- "schema1" has tables "myTable1" and "myTable2", and function "myFunction"
- "schema2" has tables "myTable1" and "myTable2", and function "myFunction"
Until now I used the full names to distinguish between schemas, like
this: schema1.myTable1 and schema2.myTable1.
But now I have to add an update trigger in both "myTable1" that calls
to a function that makes a select statement on "myTable2".
The problem is that even if the trigger is inside "mySchema1", it
can't find "myTable2" and I don't know how to get the schema that the
function is into.
Things I have tried so far:
- current_schema() but, according to the documentation, it "returns
the name of the schema that is first in the search path" and that is
neither "mySchema1" or "mySchema2".
- Passing a parameter to the trigger: since it is an update trigger I
haven't found a way to pass parameter to it.
Can anyone please point me in the right direction?
Thanks in advance!
Juan M.
From | Date | Subject | |
---|---|---|---|
Next Message | Don | 2011-08-31 15:51:46 | Re: out of memory - no sort |
Previous Message | Scott Marlowe | 2011-08-31 15:24:21 | Re: heavy swapping, not sure why |