[GENERAL] triggers using the correct schema ..

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[GENERAL] triggers using the correct schema ..

Paul Newman

Hi,

We have lots of schemas .. one of which is public. They all have the same set of tables and some of these have triggers. However when a trigger is fired in a schema it works on tables in the public schema instead of the “current” schema. We can put a statement similar to set search_path = “schema_x”; in the front of each trigger … but we use a script to generate these schemas so means doing a search and replace for each creation that we do. Is there a CURRENT SCHEMA type of command such that we could do …. Set search_path = CURRENT SCHEMA ?????

 

Thanks

Paul Newman

Reply | Threaded
Open this post in threaded view
|

Re: [GENERAL] triggers using the correct schema ..

GIROIRE, Nicolas (COFRAMI)
Hi,
you can use
SET search_path TO :"defaultSchema";
with replacing "defaultSchema" by the name of schema you want as default.
 
Then all create are automatically done in this schema.
 
Nicolas

 -----Message d'origine-----
De : [hidden email] [mailto:[hidden email]]De la part de Paul Newman
Envoyé : vendredi 20 mai 2005 13:04
À : [hidden email]
Objet : [GENERAL] triggers using the correct schema ..

Hi,

We have lots of schemas .. one of which is public. They all have the same set of tables and some of these have triggers. However when a trigger is fired in a schema it works on tables in the public schema instead of the “current” schema. We can put a statement similar to set search_path = “schema_x”; in the front of each trigger … but we use a script to generate these schemas so means doing a search and replace for each creation that we do. Is there a CURRENT SCHEMA type of command such that we could do …. Set search_path = CURRENT SCHEMA ?????

 

Thanks

Paul Newman