[GENERAL] Throwing exceptions

Hi, I need a way to throw a message in a function, when an exception occurs, but I don't want to write again and again the same message in every place I need to throw it. So, is there a way to handle this situation in a more general manner? Thanks in advance, -- Germán Hüttemann Arz

[GENERAL] Throwing exceptions

Hi, I need a way to throw a message in a function, when an exception occurs, but I don't want to write again and again the same message in every place I need to throw it. So, is there a way to handle this situation in a more general manner? Thanks in advance, -- Germán Hüttemann Arz

[GENERAL] Auditing a database

application suggested that probably would be better to insert the old record because it is simpler to follow the trace of updates. What you suggest? Regards, -- Germán Hüttemann Arza CNC - Centro Nacional de Computación UNA - Universidad Nacional de Asunción Campus Universitario, San Lorenzo

[GENERAL] Auditing a database

application suggested that probably would be better to insert the old record because it is simpler to follow the trace of updates. What you suggest? Regards, -- Germán Hüttemann Arza CNC - Centro Nacional de Computación UNA - Universidad Nacional de Asunción Campus Universitario, San Lorenzo

[GENERAL] Enable/Disable Triggers

e you can help me. Regards, -- Germán Hüttemann Arza CNC - Centro Nacional de Computación UNA - Universidad Nacional de Asunción Campus Universitario, San Lorenzo - Paraguay http://www.cnc.una.py  - Tel.: 595 21 585550 ---(end of broadcast)--- TIP

[GENERAL] Triggers

the advantages/disadvantages of that? Where can I find more information? -- Germán Hüttemann Arza

[GENERAL] Error handling inside PL/pgSQL functions

I am writing triggers procedures in PL/pgSQL and I need to handle some errors inside the procedures. Specifically, I am doing a CAST(char AS integer) and I want to know when the char isn't a digit. How can I get do that? Regards,-- Germán Hüttemann

[GENERAL] PostgreSQL Internals

x27;t find much. I also looked at the documentation at the web site with same results.Where can I find such information? I hope you can help me find what I looking for. Regards,-- Germán Hüttemann Arza

[GENERAL] Error using OLD and NEW records

substr(TG_OP, 1, 1), now(); RETURN NEW; END IF; RETURN NULL; END;' LANGUAGE plpgsql; It is very similar to the example for auditing a table shown in the documentation of the pgAdminIII, but it doesn't work at all. Could you help me with this problem? Thanks, -- Germán Hüttema