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

2005-05-20 Thread GIROIRE, Nicolas (COFRAMI)
L PROTECTED]De la part de Paul NewmanEnvoyé : vendredi 20 mai 2005 13:04À : pgsql-general@postgresql.orgObjet : [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.

[GENERAL] triggers using the correct schema ..

2005-05-20 Thread 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_pat