| From: | gmb <gmbouwer(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: debugging triggers - get original statement? |
| Date: | 2014-01-15 11:30:07 |
| Message-ID: | 1389785407565-5787212.post@n5.nabble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Thanks for your reply, Lucazeo.
> BUT: it is dangerous in production: you can fill your file system very
> fast and slow down the system.
Yes, this was my concern as well. In my current situation this may be too
risky.
>Another way is: modify the trigger and write informations you need in
>a specific table. Not an elegant solution but...
Exactly what I had in mind, but I hoped to be able to log the original
statement as well .
In that way I can simulate the problem-causing transactions exactly in a
more controlled env by running the scripts as in the log table.
Thanks any way.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/debugging-triggers-get-original-statement-tp5787181p5787212.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bricklen | 2014-01-15 15:25:47 | Re: debugging triggers - get original statement? |
| Previous Message | Luca Vernini | 2014-01-15 11:22:15 | Re: debugging triggers - get original statement? |