[HACKERS] pg_dump - failed sanity check, type
(First of all, is this the right list?) When doing pg_dump testdb -u I get failed sanity check, type with oid 899762 was not found I searched my backend log for this oid and found something near the 'tryme' function. As far as I can find I have two functions defined with different args and one has a problem. These are an old unused functions I wrote in plpgsql. I'm guessing that if I remove them the problem will go away. Result | Function | Arguments ---+---+-- bool | tryme | - bool | tryme | record testdb=# select proargtypes from pg_proc where proname='tryme'; proargtypes - 298035 899762 (2 rows) Am I making sense? .. comments? What's going on? Thanks -Cedar ---(end of broadcast)--- TIP 3: 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
[HACKERS] triggered data change violation
Added note: The trigger is a BEFORE trigger. -- Forwarded message -- To: [EMAIL PROTECTED] Date: Tue, 20 Mar 2001 20:43:59 +0200 (IST) Subject: triggered data change violation ERROR: triggered data change violation on relation "tblstsc2options" What is this? It doesn't happen unless I'm in a transaction. I'm INSERTing a record and then DELETEing it (in the same transaction) and on delete I get this error. If I commit and begin a new transaction before the delete everything is fine. Is it something my trigger causing? I don't have any UPDATE, INSERT, or DELETE statements in my trigger (and I am returning old on delete). Thanks, -Cedar ---(end of broadcast)--- TIP 3: 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