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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
