| From: | Peter Kovacs <peter(dot)kovacs(at)chemaxon(dot)hu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | HH <lists(at)lastonepicked(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can't Figure Out Where Rows Are Going |
| Date: | 2006-05-07 07:57:53 |
| Message-ID: | 445DA881.8050700@chemaxon.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Aside from the suggestion already made that the inserting transaction
> got rolled back instead of committed, I'd wonder about indirect
> deletions due to ON DELETE CASCADE foreign keys, or deletions executed
> by PL-language functions. Neither of those would produce obvious log
> entries for their effects...
>
Is there no way to trace all SQL statements executed including
PL-language functions? There is at least one functional unit in
PostgreSQL (the optimizer for example) which does at least some
processing of all SQL statements, I presume.
Thanks
Peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Sidney-Woollett | 2006-05-07 08:11:10 | Re: Can't Figure Out Where Rows Are Going |
| Previous Message | HH | 2006-05-07 07:29:28 | Re: Can't Figure Out Where Rows Are Going |