From: | Susan Cassidy <scassidy(at)stbernard(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | question about log entry from trigger execution |
Date: | 2010-05-05 16:48:09 |
Message-ID: | 3A51F387FE0CC74D80FA60C146987F250191A97541DC@oc-exchange1.stbernard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a database I inherited with a number of triggers defined on various tables.
One AFTER trigger, when executed, causes a database log entry with a "CONTEXT" entry, but no ERROR. I normally only see the CONTEXT entries when an ERROR occurs.
The trigger is on table rbs, and it returns NULL.
Here are the entries (slightly edited):
May 5 16:08:21 postgres[18723]: [598-1] 2010-05-05 16:08:21 UTC LOG: statement: DELETE FROM rbs WHERE id = 136259855 AND cid = 601
May 5 16:08:21 postgres[18723]: [599-3] 2010-05-05 16:08:21 UTC CONTEXT: SQL statement "UPDATE uinfo UI SET id_bitmap = (id_bitmap & ~(1::bit(128) << (C.bitmap_index
May 5 16:08:21 postgres[18723]: [599-4] - 1)) ) FROM cinfo C WHERE UI.id = $1 AND $2 = C.cid"
May 5 16:08:21 postgres[18723]: [599-5] ^IPL/pgSQL function "rbs__adel" line 6 at SQL statement
May 5 16:08:21 postgres[18723]: [600-1] 2010-05-05 16:08:21 UTCLOG: statement: COMMIT
The statement that seems to be logged is:
UPDATE uinfo UI
SET id_bitmap = (id_bitmap & ~(1::bit(128) << (C.bitmap_index - 1)) )
FROM cinfo C
WHERE UI.id = OLD.id AND OLD.cid = C.cid;
The update seems to get done ok. I still wonder what the log entry is trying to tell me.
This is PostgreSQL 8.3.
Any ideas?
Susan
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-05-05 17:02:30 | Re: question about log entry from trigger execution |
Previous Message | Nikola | 2010-05-05 16:40:45 | pg_class has 3615 rows and 1010Mb in table size |